PurpleSnow
New Member
- Joined
- Apr 1, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi - I am currently working on recording a macro to help make some of my excel spreadsheets work better. The master spreadsheet has a list of names and ID number which needs to be collated from a report run from an external system. At the moment this is a copy and paste into the master. Each month a report is produced which provides information that needs to be input into the master - I use Vlookup at the moment.
I can record each step for the above processes for the first month but not sure how to get it to run for each month so that by the end of the year there are 12 months of data in the master spreadsheet. Any suggestions would be very welcome.
I can record each step for the above processes for the first month but not sure how to get it to run for each month so that by the end of the year there are 12 months of data in the master spreadsheet. Any suggestions would be very welcome.