View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ed Davis[_2_] Ed Davis[_2_] is offline
external usenet poster
 
Posts: 67
Default Getting Info from Last cell used

I put this an another newsgroup and did not get a reply so thought I would
try here.


Currently I am adding many sheets together. I am using "Start Sheet" and
"End Sheet" and everything in between those two sheets is adding for a
total.
I would (in a few cells) to just get the data from the last cell used.

Example:
The sheets I am adding are dates and if sheet 01-19-09 (dd-mm-yy) has the
last entry in cell c18 I would like that number. However there may be blank
cell before that sheet. and after that sheet there will be info in other
cells.
I would like that info to go into c18 of the sheet I use and named "Totals".

--
Thank You in Advance
Ed Davis