Dragging formula linked to diff sheets
 

I have multiple spreadsheets in the same workbook, with a "totals"
sheet. Each individual sheet is exactly the same except for the
business name. On the totals sheet I want to drag the whole line of
linked formulas down, then (quickly) change the reference portion to
the correct sheet. Is there a quicker way to do that besides selecting
the row and 'replacing' the sheet reference? When I do that, some will
not replace correctly, 'blowing up' the formula causing me to link each
cell's formula (12 columns across)from the 'totals' sheet back to the
individual company sheet.

--Thanks
Chrism

Take a look at
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Chrism" wrote in message oups.com...
I have multiple spreadsheets in the same workbook, with a "totals"
sheet. Each individual sheet is exactly the same except for the
business name. On the totals sheet I want to drag the whole line of
linked formulas down, then (quickly) change the reference portion to
the correct sheet. Is there a quicker way to do that besides selecting
the row and 'replacing' the sheet reference? When I do that, some will
not replace correctly, 'blowing up' the formula causing me to link each
cell's formula (12 columns across)from the 'totals' sheet back to the
individual company sheet.

--Thanks
Chrism

Awesome: Thanks!