View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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.