I have two workbooks, both with matching headers. Data is entered in one workbook (let's call it workbook1) on a row by row basis with a timestamp of when the data was entered. So each new entry is on the next row down from the previous one with an associated unique timestamp.
I need a macro in the second workbook (workbook2) that will find the row in workbook1 matching the timestamp of the latest row in its own sheet, and then I need to copy all the new rows that are below it in workbook1.
ie,
WORKBOOK1
MACHINE EMPLOYEE CAUSE TIMESTAMP
535A 123 Crack 12/12/2012 10:11
535B 123 Power 12/12/2012 10:15
61C 423 Damage 12/12/2012 12:23
535A 123 Crack 12/13/2012 09:53
WORKBOOK2
MACHINE EMPLOYEE CAUSE TIMESTAMP
535A 123 Crack 12/12/2012 10:11
535B 123 Power 12/12/2012 10:15
Macro needs to match '12/12/2012 10:15' from workbook2 with workbook1, then copy the subsequent rows to the end of workbook2:
61C 423 Damage 12/12/2012 12:23
535A 123 Crack 12/13/2012 09:53
I am rather stumped. Help would be greatly appreciated.
Bookmarks