View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
 
Posts: 972
Default 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