Getting info from the last used cell

  • Thread starter Microsoft Communities
  • Start date
M

Microsoft Communities

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

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

Top