I'm trying to write a code which takes an old list of values and compares it with a new master list. If the code finds a value from the old list matches one on the new list, I would like the code to copy several cells of data and paste them onto the new master list. Essentially moving all the old matching data to a new list.

Example

Master List--------Old List--------Old Data (columns 3-20)
11----------------2--------------asd
A------------------4--------------asd
B------------------K--------------sdgsd
12----------------11-------------sff
K------------------Q--------------jtfgkfk
N------------------A--------------sdhtsdh

Result

Master List-------Old Data Transfered to matching row
11----------------sff
A-----------------sdhtsdh
B
12
K-----------------sdgsd
N


This is what I have so far. Note I receive an error on like "vToFind = Sheets..."

Please Login or Register  to view this content.
Thanks