carry over

  • Thread starter Thread starter s
  • Start date Start date
S

s

Hi

I have a excel 2000 workbook with numerous sheets at the
end of each sheet is a running total whcih needs to be put
on the next sheet as a carry over and then added to.

Can anybody help??

Thanks
 
this will find the last number on sheet2 in col B. The trick is to look for
a large number that can't exist. Just make sure that your number is not
larger than your criteria.
=INDEX(Sheet2!B:B,MATCH(9999999999,Sheet2!B:B),1)
 
S,

In the next sheet, select the cell that's to have the prior sheet's total.
Press =. Select the prior sheet, select the total cell, press Enter. You
have to do this for each sheet.
If you reorder the sheets, the total will be gotten from the original sheet,
not the physically prior sheet.
 
That's clever Don. It's even immune to someone entering letters,
or spaces at the bottom of the column. Not that anyone ever
would <grin>.
 
Back
Top