Bringing Last line of worksheet to a Summary page
Debbie,
I would suggest putting your totals formula (I assume that is what they
are) on the top row of each sheet, so that they will be something like:
=SUM(A3:A500)
allowing row 2 for headings and up to 500 for data. This way the
formulae in your summary sheet will always get the data from row 1 of
the detailed sheets. In the detailed sheets you can arrange for the
range to be as large or as small as the data you expect.
Hope this helps.
Pete
|