Re: Find and print last row

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi

Without using a macro, if all of the data in column B of Sheet1 is text,
then enter in A1 of *** 3
=LOOKUP("ZZZZZZZZ",Sheet1!B:B)
If the data on *** 1 is numeric, then use
=LOOKUP(99^99,Sheet1!B:B)
--
Regards
Roger Govier



"pcor" <pcor@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:12A6E676-3109-4B2C-AD80-2C133DD7F9AB@xxxxxxxxxxxxxxxx
I would like to have a macro on a Button on *** 3 that would do the
following
Go to B1 on *** 1 and find the lAST entry on col B
Now I want the Data that appears on the last row of col b to be printed on
*** 3 cell A!
Thanks


.

Quantcast