Find and print last row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
Back
Top