Find and print last row

P

pcor

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
 
R

Roger Govier

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Section and Page numbering 0
Finding the right style field in VBA 0
Help with column accumulation needed 2
Finding the proper style field and the numbered paragraph value within the style 0
VBA for Dependents shortcut menu 0
Trendline Question 0
Make first imported CSV row into column names ? 3
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15

Top