ExcelBanter - Find and print last row

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Find and print last row (https://www.excelbanter.com/new-users-excel/152243-find-print-last-row.html)

pcor

Find and print last row

I would like to have a macro on a Button on sheet 3 that would do the following
Go to B1 on sheet 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
Sheet 3 cell A!
Thanks

Roger Govier[_2_]

Find and print last row

Hi

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

"pcor" wrote in message
...
I would like to have a macro on a Button on sheet 3 that would do the
following
Go to B1 on sheet 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
Sheet 3 cell A!
Thanks

All times are GMT +1. The time now is 07:23 AM.