tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi everyone,
I have 3 sheets,
Data Now,
Data Start
Data Old.
All are set up the same. with data in the same rows and columns so if row 20 is client A its client A in all of them.
now heres what i need,
I want a macro that when run checks sheet "Data Now" down colum D and finds any dates that are "today()"
It then goes to sheet "Data Start" and copies Range "B:AY" of that row into "Data Old" in the same row, updatng the data.
then does the next row ect. there might be blank rows and we need to skip these if possible.
Please help f you can thank Tony
I have 3 sheets,
Data Now,
Data Start
Data Old.
All are set up the same. with data in the same rows and columns so if row 20 is client A its client A in all of them.
now heres what i need,
I want a macro that when run checks sheet "Data Now" down colum D and finds any dates that are "today()"
It then goes to sheet "Data Start" and copies Range "B:AY" of that row into "Data Old" in the same row, updatng the data.
then does the next row ect. there might be blank rows and we need to skip these if possible.
Please help f you can thank Tony