Forum Discussion

Copper Contributor

Oct 27, 2022

Solved

Dynamic Column Range in a Sum Across Multiple Spreadsheet Formula

I am using weekly timesheet data that is copied into separate spreadsheets tabs. I am using a report spreadsheet to aggregate the data for weekly numbers and cumulative to-date figures based on proje...

excel

Formulas and Functions

Patrick2788
Oct 27, 2022
The best solution may not be the one you're looking for in this case. Take a step back and consider the future of the workbook and what will happen with more data being added as time goes on. Your formula works for the present state of the workbook, but will it hold up with updates and be easy to manage?

You might consider consolidating similar data in 1 sheet. It may take some re-structuring, but it would be much easier to analyze and maintain. This might be the best option without access to VSTACK.

Patrick2788

Silver Contributor

Oct 27, 2022

The best solution may not be the one you're looking for in this case. Take a step back and consider the future of the workbook and what will happen with more data being added as time goes on. Your formula works for the present state of the workbook, but will it hold up with updates and be easy to manage?

You might consider consolidating similar data in 1 sheet. It may take some re-structuring, but it would be much easier to analyze and maintain. This might be the best option without access to VSTACK.