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

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