Linking and keeping total Column at the Bottom

I am linking data in to a monthly report spreadsheet. For example, I will
link 10 lines of data and then I have a "Total" row in line 11. I would like
to know how I could keep the total row constant even if I link more than 10
lines at a a time. For example, if I have 12 rows that I am linking in a
month, my "Total" row would be overwritten. How can I keep my "total" line
the last line regardless of how many rows I link?


Thanks.

--
Bob

demechanik
Sat Mar 15 05:40:00 CDT 2008

In Sheet1,
For the "Totals", maybe you could try something like this to grab the number
=INDEX(Sheet2!B:B,MATCH("Totals",Sheet2!$A:$A,0))
Above assumes that the text "Totals" is unique in Sheet2's col A
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bob" wrote:
> I am linking data in to a monthly report spreadsheet. For example, I will
> link 10 lines of data and then I have a "Total" row in line 11. I would like
> to know how I could keep the total row constant even if I link more than 10
> lines at a a time. For example, if I have 12 rows that I am linking in a
> month, my "Total" row would be overwritten. How can I keep my "total" line
> the last line regardless of how many rows I link?
>
>
> Thanks.
>
> --
> Bob