The code below is being used to automatically transfer data from one workbook to another based on a job number and a sequence number matching. The problem that I am running into is that multiple jobs have the same sequence number and it is copying the same data into each job. For example:
Worksheet #1 of Workbook #2
Job #1, Seq. #1
Worksheet #2 of Workbook #2
Job #2, Seq. #1
The information for Job #1, Seq. #1 is being transferred over to the destination workbook in both of the above cases.
Please Login or Register to view this content.
Bookmarks