Trundlethegr8
New Member
- Joined
- Jan 26, 2022
- Messages
- 6
- Office Version
- 365
- 2016
- Platform
- Windows
Good morning,
I am tracking customer expenditures. I have a Summary sheet that lists all the Customers and shows the current expenditure data. Each day I copy the data for each Customer to their individual tab and have a historical data set to reference later on. I am trying to set it up to copy rows from my Summary sheet and paste into the sheet name that matches column A. On the destination sheets, id like the existing data to be moved down one row prior to pasting the new data in row 2 so that I have a log of each entry. Row 1 has the column titles.
I am just beginning to use VBA and I currently have it set up to copy row 4 to sheet 1, row 5 to sheet 2, etc. and it definitely has its limits.
I am using Excel 2016 and on a PC.
Any help or advice would be greatly appreciated.
Thanks!
I am tracking customer expenditures. I have a Summary sheet that lists all the Customers and shows the current expenditure data. Each day I copy the data for each Customer to their individual tab and have a historical data set to reference later on. I am trying to set it up to copy rows from my Summary sheet and paste into the sheet name that matches column A. On the destination sheets, id like the existing data to be moved down one row prior to pasting the new data in row 2 so that I have a log of each entry. Row 1 has the column titles.
I am just beginning to use VBA and I currently have it set up to copy row 4 to sheet 1, row 5 to sheet 2, etc. and it definitely has its limits.
I am using Excel 2016 and on a PC.
Any help or advice would be greatly appreciated.
Thanks!