I have a spreadsheet summary sheet that references change order totals from
multiple worksheets. Each row on the spreadsheet summary references a
'subtotal' cell on sucessive change order worksheets. The total cell is the
same in each sheet. As I copy additional worksheets, is there a way to
automatically reference the total with out manually referencing the worksheet
total to the summary cell.

Hi,

It sounds like you are asking - If you add a sheet can the Summary sheet
pick of the total cell from the new sheet.

If that is the case, maybe -
1. if the total cell is in same cell on all sheets
2. if you can insert the new sheet between the first and last sheets that
are being summed
3. if there are no sheets between the first an last sheet which you don't
want summed

If those condtions are met, then suppose the first sheet is named First and
the last sheet is named Last, and the total cell is in T20 on all the sheets,
then you can use a formula of the following type

=SUM(First:Last!T20)

If this helps, please click the Yes button

Cheers,
Shane Devenshire
"Hulqscout" wrote:

I have a spreadsheet summary sheet that references change order totals from
multiple worksheets. Each row on the spreadsheet summary references a
'subtotal' cell on sucessive change order worksheets. The total cell is the
same in each sheet. As I copy additional worksheets, is there a way to
automatically reference the total with out manually referencing the worksheet
total to the summary cell.

Your close. I am not totaling the change orders just showing on the
succesive row. For example: the first row of the summary sheet lists the
total of CO1,
the second row lists the total from CO2, the third row list the total from
CO3, etc.
The summary sheet has a grand total of each row.


"Shane Devenshire" wrote:

Hi,

It sounds like you are asking - If you add a sheet can the Summary sheet
pick of the total cell from the new sheet.

If that is the case, maybe -
1. if the total cell is in same cell on all sheets
2. if you can insert the new sheet between the first and last sheets that
are being summed
3. if there are no sheets between the first an last sheet which you don't
want summed

If those condtions are met, then suppose the first sheet is named First and
the last sheet is named Last, and the total cell is in T20 on all the sheets,
then you can use a formula of the following type

=SUM(First:Last!T20)

If this helps, please click the Yes button

Cheers,
Shane Devenshire
"Hulqscout" wrote:

I have a spreadsheet summary sheet that references change order totals from
multiple worksheets. Each row on the spreadsheet summary references a
'subtotal' cell on sucessive change order worksheets. The total cell is the
same in each sheet. As I copy additional worksheets, is there a way to
automatically reference the total with out manually referencing the worksheet
total to the summary cell.