Copy and Paste between worksheets on ID match

**dems** · 03-11-2010, 05:43 AM

Hi guys,

Having a problem copy and pasting rows across from one worksheet to another based on a variable match between these two sheets.

The variables to match are the ID columns, and I am looking to transfer the data into the relevant row from Master worksheet to SCCG worksheet. We can leave the rows blank for the IDs in the SCCG worksheet that dont match.

Tried giving it a shot, but not having much luck. Would really appreciate some direction.

Please Login or Register  to view this content.

I have attached an example workbook to get across the idea. The real life file is scaled much larger (hence the preference for a macro).

Thanks for any help!

D

**ravishankar** · 03-11-2010, 06:29 AM

Hi
try the macro in the attached file
Ravi

**dems** · 03-11-2010, 07:39 AM

Thanks for the reply Ravi!

Unfortunately I am having issues applying vlookup on my actual file, as such I was hoping to write this with a nested loop.

**ravishankar** · 03-11-2010, 12:09 PM

Originally Posted by dems

Thanks for the reply Ravi!

Unfortunately I am having issues applying vlookup on my actual file, as such I was hoping to write this with a nested loop.

HI
here is a macro with nested loops to get the same output
Ravi

**JBeaucaire** · 03-11-2010, 01:06 PM

A non-macro solution...enter this formula in SCCG cell B2, then copy it to the whole table:

=IF(ISNUMBER(MATCH($A2, Master!$A$2:$A$19, 0)), INDEX(Master!$B$2:$H$19, MATCH($A2, Master!$A$2:$A$19, 0), MATCH(B$1, Master!$B$1:$H$1, 0)), "")

Even on a large file, INDEX/MATCH is extremely robust.