How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Richard Your Own Question

Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 31327
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

from one excel sheet I want to replace data to other sheet

This answer was rated:

from one excel sheet I want to replace data to other sheet applying more than one condition
Thank you for your question, my name is Richard.

Unless you use a Macro, you need to put the actual formula in the cell you want to replace for.

So if you want C1 to be A if A1 is Blue, or B if it is not, then you put in C1

=IF(A1="Blue", "A", "B")

Is this what you are trying to achieve?

If not, can you provide some more detail please?

Thank you
Customer: replied 3 years ago.

No It is not that simple.


 


Please see attached file with sheet A and Sheet B


 


I want to replace Item Code (Column I) and Dept (Column J) in sheet B with the Data from Sheet A where Sheet B Coulmn A Matches SheetA Column A)

Attachment: 2013-09-24_165913_learn_excel.xls

ok, this needs to be a Macro, not a formula

I have written the Macro for you

Download the sheet from my link below

http://tinyurl.com/m8af46n

On Sheet B you see the button to run the Macro

If you have any problems, or would like any additional information or assistance, please do not hesitate to let me know.

And if you can take a second to rate my service, that would be greatly appreciated.

Thank you
Customer: replied 3 years ago.

You did exactly what I need.


 


How I can read the content of Macro?

Press ALT + F11

This opens the developer (Visual Basic) Window

Double click on Sheet 2 and you see it there.

Let me know if you need anything else

And please remember the Service rating

Thank you
Customer: replied 3 years ago.

Thanks a lot.


 


I may use this small Macro for different excel data basis after making changes in mthis small program (Macro) as per my requirements.


 


To do this what kaind of basic program I need and How I open that utility and how I save that Macro after modifications...

You do it all within Excel, no extra programs needed.

You press ALT + F11

It opens the visual basic in Excel

And you can then write your Macro, or copy mine and paste it there.

Nothing extra is needed.

Richard and 2 other Microsoft Office Specialists are ready to help you