Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Find and print last row
2 views
Skip to first unread message
pcor
Jul 30, 2007, 11:10:01 AM7/30/07
to
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
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
Jul 30, 2007, 11:27:11 AM7/30/07
to
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" <pc...@discussions.microsoft.com> wrote in message
news:12A6E676-3109-4B2C...@microsoft.com...
0 new messages