CLINT WILLIAMS
Board Regular
- Joined
- Nov 8, 2011
- Messages
- 69
- Office Version
- 365
I am new at this so would appreciate any help. I am trying to compare two cells using if function in sheet1 eg "K" & "L" . k = cell no and L = date to sheet2 which has the same data. if there is a match I want to copy the row to sheet3.
However when matching the date I want the macro to look for the same day or the next day. This also needs to loop as each sheet has thousands of data.
Thanks
Clint
However when matching the date I want the macro to look for the same day or the next day. This also needs to loop as each sheet has thousands of data.
Thanks
Clint