Linking and keeping total Column at the Bottom

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Totaling columns 4
Last number in a column shows in the total/summay line cell 3
Running Total Column 1
Excel Getting an annualized figure based on YTD in Excel 1
Subtotal percents in pivot table 1
keeping a "floating cell"'s value 1
summing multiple lines throughout spreadsheet 2
Atomatic subtotal in every pages. 1

Back
Top