 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2007Find 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 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)  SignatureRegards Roger Govier >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
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.