- Apr 2, 2021
- Office Version
I want a VBA that will automatically copy/paste data from sheet1 to sheet2.
It should copy the Oracle value(D4:D8), Name(E4:E8), Code(F4:F8) and the date of the day (F2).
So in example below. I have 4 agents, they were all present on April 2nd.
I now want to move all that data onto sheet2 in the sheet below.
Now when we get to tomorrow I want it to copy the same but for April 3rd (G2).
It should not overwrite any additional data. It should not copy the data if the code cell is blank (F4:F8)