K
Kcope8302
I am having an issue with a Macro. The macro will look at column A between 2
worksheets (PTR and Reference Data). If what is in column A in Reference Data
worksheet matches Column A in PTR it will then copy 4 cells from that
row(L,M,N and O) and paste them in the PTR worksheet starting at column W.
Example
PTR – Before the Macro
A .......... W X Y
Z
CR94875
Reference Data - Data that would need to be copied if a match is found
A ………. L M N O
CR94875 TBD On-Time 5/25/09 Source List
PTR – After a match was found in column A
A .......... W X Y
Z
CR94875 TBD On-Time 5/25/09 Source List
worksheets (PTR and Reference Data). If what is in column A in Reference Data
worksheet matches Column A in PTR it will then copy 4 cells from that
row(L,M,N and O) and paste them in the PTR worksheet starting at column W.
Example
PTR – Before the Macro
A .......... W X Y
Z
CR94875
Reference Data - Data that would need to be copied if a match is found
A ………. L M N O
CR94875 TBD On-Time 5/25/09 Source List
PTR – After a match was found in column A
A .......... W X Y
Z
CR94875 TBD On-Time 5/25/09 Source List