Hi everyone, I have 2 identical spreadsheets in terms of layout. The source file which is where the data pulls from, and the main file - which is used as the working document.
I am looking for some VBA code that will pull the rows of data from the source file into the main file where they don't already exists.
The unique hooks here are column's B, H, I and N.
So the Macro would sit in the main file, would go into the Source file and identify that lines 3,4,5 and 6 are not present in the main file and bring them across.
However, there is one rule to factor in, if the date in column N is before 01/03/23 (1st March 2023) the line should be ignored. Any coding guru able to assists with this please as I think it will be quite simple for someone who knows how to approach this?
Example file's attached and de-sensitised
Bookmarks