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

hi
I would (in a few cells) to just get the data from the last cell used.

so far as i know, excel does not record the last cell used much less the
last cell used on multiple sheets.
you would have to define what constitutes the last cell used and design from
there.
if you cannot define what constitutes the last cell used then i think your
quest may be...uh....difficult.

regards
FSt1


"Ed Davis" wrote:

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