tmskipper86
New Member
- Joined
- Jun 16, 2021
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Hello,
I am trying to trying to create a Macro to move information from my 'Export' file to my 'Yearly' file based off the worksheet name in the Yearly file. In the 1st screenshot below, I need to copy all rows and only column A to P, and then move these rows to the matching worksheets in the Yearly file (see 2nd screenshot). S
So for example, I need to move all rows with 'CA' in column Q from the 'Export to 'CA' in the yearly. This will be pasted on the 1st empty cell in column A. The amount of states and rows will change week to week on the Export file. Any guidance or suggestion would greatly help
1
I am trying to trying to create a Macro to move information from my 'Export' file to my 'Yearly' file based off the worksheet name in the Yearly file. In the 1st screenshot below, I need to copy all rows and only column A to P, and then move these rows to the matching worksheets in the Yearly file (see 2nd screenshot). S
So for example, I need to move all rows with 'CA' in column Q from the 'Export to 'CA' in the yearly. This will be pasted on the 1st empty cell in column A. The amount of states and rows will change week to week on the Export file. Any guidance or suggestion would greatly help
