Hi all, I am having trouble figuring out how to match Time & Date in 2 different sheets using VBA.
I have 2 sheets.
In Sheet 1, I will generate 1 list of date & time (example of cell A1 "24/11/22 15:20").
I will then copy this data to Sheet 2.
I need a VBA code to verify if cell A1 had already been copied in sheet 2 so I can override and copy from the same cell downwards to A2...3...4...5... etc
Example:
Sheet 1 Cell A1 value : "24/11/22 15:20"
Sheet 1 Cell A2 value : "24/11/22 16:20"
If exact Cell value A1 is found in Sheet 2 column A, row 16 (Sheet 2 A16), I will need to paste Sheet1 A1 to Sheet2 A16 & Sheet1 A2 to Sheet2 A17.
If exact Cell value A1 is NOT found in Sheet 2 column A, I will need to start the paste form last empty cell in Sheet 2 Column A.
Any kind help from the experts is greatly welcomed thank you.
I have 2 sheets.
In Sheet 1, I will generate 1 list of date & time (example of cell A1 "24/11/22 15:20").
I will then copy this data to Sheet 2.
I need a VBA code to verify if cell A1 had already been copied in sheet 2 so I can override and copy from the same cell downwards to A2...3...4...5... etc
Example:
Sheet 1 Cell A1 value : "24/11/22 15:20"
Sheet 1 Cell A2 value : "24/11/22 16:20"
If exact Cell value A1 is found in Sheet 2 column A, row 16 (Sheet 2 A16), I will need to paste Sheet1 A1 to Sheet2 A16 & Sheet1 A2 to Sheet2 A17.
If exact Cell value A1 is NOT found in Sheet 2 column A, I will need to start the paste form last empty cell in Sheet 2 Column A.
Any kind help from the experts is greatly welcomed thank you.