| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| M/S cannot find anything to print | Excel Discussion (Misc queries) | |||
| find, select and print | Excel Discussion (Misc queries) | |||
| Find print area | Excel Discussion (Misc queries) | |||
| Excel can't find anything to print | Excel Discussion (Misc queries) | |||
| Microsoft Excel could not find anything to print | Excel Discussion (Misc queries) | |||
Hybrid Mode
