Hi all,
I have a budget workbook with 40 tabs, each laid out identically. Column A list the type of expense (rent, salaries, etc), and column B has the total expenses for the year.
I want to have a new tab set up to summarize the data by tab. So Column a wolud be the same, column B would include the data for the marketing team 1, column be could contain data for operations, and so on, until the 41st column has a sum of the tabs.
It's a similar concept to a pivot table, only that the data is in multiple tables.
Any thoughts or help would be greatly appreciated!!
I have a budget workbook with 40 tabs, each laid out identically. Column A list the type of expense (rent, salaries, etc), and column B has the total expenses for the year.
I want to have a new tab set up to summarize the data by tab. So Column a wolud be the same, column B would include the data for the marketing team 1, column be could contain data for operations, and so on, until the 41st column has a sum of the tabs.
It's a similar concept to a pivot table, only that the data is in multiple tables.
Any thoughts or help would be greatly appreciated!!