Hi all thanks for the help in advance,
I am having an issue. I have 2 datasets in worksheets in the same workbook say worksheet 1 and worksheet 2. Both Data sets are date and time stamped in columns A and B respectively. I would like to be able to write a macro to search for the matching row of time stamped data in worksheet 1 and 2 then copy both rows of data into a new worksheet, worksheet 3. Not sure if the vlookup function should be used here or if I am better off just trying to copy one set of data directly to worksheet 3 and just search for and add the other set of data by matching time stamps. Any help would be greatly appreciated.
Bookmarks