Help With Copy Data From Sheet1 Cell to Sheet2 Cell

[gaspower]

Hello,

I have a workbook with sheet1 and sheet2. Each sheet I am only dealing with columns A-D. The data in column A in both sheets is the unique identifier. The below macro I am using will take sheet1 (ColumnA) and compare to sheet2 (ColumnA). If the identifies are the same in both cells it will highlight it green.

What I need to add to the below macro is the ability to add a cell copy over. So sheet1 being my master, if sheet1 and sheet2 have a equal identifier in column A, the data from sheet1 B,C,D for that row will be copied over to sheet2 of its equal identifier sheet2 B,C,D.

I have attached a sample.

Please Login or Register  to view this content.

[KrisSquare]

I do not think this requires a macro. check the attached file that gives the same functionality with conditional formatting and Vlookup


If you feel Macro is definitely needed use below code

Please Login or Register  to view this content.

[gaspower]

Hello Kris,

thank you for the reply. I would prefer to use a macro, this way I can put in my personal.xls. I tried the macro code you mentioned, but all it did was highlight green row "A" items in sheet1 and sheet2. Did not copy over BCD to sheet2.

Thank you,
JR

[KrisSquare]

Try this. I have edited the code

Please Login or Register  to view this content.

[gaspower]

Hello,

Seems to work fine. I thank you very much for your time and effort in helping me...

Best Regards