Tigerexcel
Active Member
- Joined
- Mar 6, 2020
- Messages
- 493
- Office Version
- 365
- 2019
- Platform
- Windows
Hi all,
I receive spreadsheets that primarily require both column and row addition. The problem is that when I receive these spreadsheets they may have a different number of rows and columns compared to the last spreadsheet. I may receive a number of them on the same day, all with differing numbers of rows/columns. What I was hoping for was a macro that totals both columns and rows and transfers the new table onto a new worksheet. There are 2 separate actions required here I guess, add the totals to whatever figures I receive, then transfer the entire worksheet to another tab within the same workbook. My main problem is working out the VBA for the changing dimensions of the tables. The tables received vary from 12 rows x 12 columns to 1000 rows x 36 columns.
I receive spreadsheets that primarily require both column and row addition. The problem is that when I receive these spreadsheets they may have a different number of rows and columns compared to the last spreadsheet. I may receive a number of them on the same day, all with differing numbers of rows/columns. What I was hoping for was a macro that totals both columns and rows and transfers the new table onto a new worksheet. There are 2 separate actions required here I guess, add the totals to whatever figures I receive, then transfer the entire worksheet to another tab within the same workbook. My main problem is working out the VBA for the changing dimensions of the tables. The tables received vary from 12 rows x 12 columns to 1000 rows x 36 columns.