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
Bookmarks