Adding extra worksheets and automatically summing their data into a summary sheet.

**JTDonovan** · 02-09-2013, 12:39 PM

Dear All,

I wonder if this is possible. I want to be able to add a new worksheet to a spreadsheet. It will always be the same sheet but will differ from the previous one based on the creation data only. I then want to be able to sum data from cells on all the sheets (old and new) into a cell on a summary sheet. I am wondering if there is a way that the summary sheet can 'spot' the new sheet and automatically pick up the data rather than me having to crack open the formulas on the summary sheet and editing them.

**alansidman** · 02-09-2013, 01:32 PM

If you make the last sheet in your workbook blank and insert the new sheet before the last sheet, then this would work

Sum(firstsheet:lastsheet!A1)

**FDibbins** · 02-09-2013, 01:33 PM

if you add a blank worksheet at the start and end of your data sheets, and call them Start and End, then when you enter your calcs, you could just enter =sum('start:End'!C12) or whatever your references are. this way, you can add or remove sheets as needed, and it will add across all the sheets you need it to, and keep the totals as the data sheets change. make sure your "Master" sheet is before the Start sheet though

**oeldere** · 02-09-2013, 01:33 PM

You get better help if you add an excel file without confidentional information.

Please also add the desired (expected) result.

Adding extra worksheets and automatically summing their data into a summary sheet.

LinkBack

Thread Tools

Rate This Thread

Display

Adding extra worksheets and automatically summing their data into a summary sheet.

Re: Adding extra worksheets and automatically summing their data into a summary sheet.

Re: Adding extra worksheets and automatically summing their data into a summary sheet.

Re: Adding extra worksheets and automatically summing their data into a summary sheet.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions