Match Copy & Paste Between 2 Wkbks Revised

[timbo1957]

Hi,

In Column A of Wkbk1 starting in row 2 I have a list of codes.

In Column A of Wkbk2 starting in row 5 I have a list of codes some of which match those of Wkbk1

I need a macro that will run down the codes in Wkbk1, and if it finds a match in Wkbk 2 copy the values in specific cells W, K, M, P, BV, AJ, BC,AZ,AY,BF,BG,AW,BR,BU,CM,AM and paste to the cells C,D,E,F,G,I,K,L,M,N,O,P,Q,R,S,W of the row where that code is sitting in Wkbk1.


Hope that makes sense.

[timbo1957]

I have simplified this thread hopefully.

[timbo1957]

I have found a piece of code which looked like it would part of my problem but it doesn't work.

It doesn't scan down col A of one workbook and match to col A of another but if it worked it would copy cells from one location to a different one.

Please Login or Register  to view this content.