choose last specific nonblank cell from different worksheets
 

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.

choose last specific nonblank cell from different worksheets
 

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.
--
Gary's Student
gsnu200703


"Compassionate Felix" wrote:

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.