choose last specific nonblank cell from different worksheets

  • Thread starter Compassionate Felix
  • Start date
C

Compassionate Felix

Hello,

I want to select the last cell with a value from a particular cell (e.g.,
A3) from several worksheets in the same workbook. Is this possible? If so,
can anyone suggest way(s) to go about it, please?

Thank you.
 
G

Gary''s Student

Very easy:

Anytime a user changes cell A3 in any worksheet, have them insert a comment
giving the date of change.

Then all you have to do is review the dates and pick the latest one.
 
Top