VoxDubitatio
New Member
- Joined
- Dec 9, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello,
I am very new to VBA but I am trying to set up a macro that will move a variable number of rows (anywhere from 1-20) with dates in column "A" from the "entry" sheet to the "tracking' sheet that has been pre-populated with dates in the same column (approximately 500 rows of dates in column "A").
After these rows are moved to the "tracking" sheet I would like the dates to be sorted into the correct positions and ideally I would like the entered data (from the "entry" sheet) to be grouped with the rows in the "tracking" sheet that have the same date.
I have included a couple of images for reference:
This is the "entry" sheet (the data to be moved)
And this is the "tracking" sheet (where I would like the data to go
Let me know if I can do anything to further clarify my request.
I am very new to VBA but I am trying to set up a macro that will move a variable number of rows (anywhere from 1-20) with dates in column "A" from the "entry" sheet to the "tracking' sheet that has been pre-populated with dates in the same column (approximately 500 rows of dates in column "A").
After these rows are moved to the "tracking" sheet I would like the dates to be sorted into the correct positions and ideally I would like the entered data (from the "entry" sheet) to be grouped with the rows in the "tracking" sheet that have the same date.
I have included a couple of images for reference:
This is the "entry" sheet (the data to be moved)
And this is the "tracking" sheet (where I would like the data to go
Let me know if I can do anything to further clarify my request.
