| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy information from the bottom
I am running a large purchase order log on excel 03. I would like to have the
information from the bottom of the log (the newest entry) copy to an actual purchase order on another worksheet in the same workbook. This way I could print off an order after I enter each log. Since the bottom of the log is always going further down is this possible? And is it possible for this to work vice versa? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy information from the bottom
If the column contains numbers, then you need:
=LOOKUP(10^307,'Sheet1'!A:A) If it contains text you need: =LOOKUP(REPT("z",255),'Sheet1'!A:A) The cell with this formula will always show the last value in column A:A of Sheet1 HTH Kostis Vezerides thebaldsoprano wrote: I am running a large purchase order log on excel 03. I would like to have the information from the bottom of the log (the newest entry) copy to an actual purchase order on another worksheet in the same workbook. This way I could print off an order after I enter each log. Since the bottom of the log is always going further down is this possible? And is it possible for this to work vice versa? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy information from the bottom
that did it! on behalf of myself and all the co-workers who were just
entertained by my impromptu football victory dance THANK YOU! "vezerid" wrote: If the column contains numbers, then you need: =LOOKUP(10^307,'Sheet1'!A:A) If it contains text you need: =LOOKUP(REPT("z",255),'Sheet1'!A:A) The cell with this formula will always show the last value in column A:A of Sheet1 HTH Kostis Vezerides thebaldsoprano wrote: I am running a large purchase order log on excel 03. I would like to have the information from the bottom of the log (the newest entry) copy to an actual purchase order on another worksheet in the same workbook. This way I could print off an order after I enter each log. Since the bottom of the log is always going further down is this possible? And is it possible for this to work vice versa? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Create a Macro to Edit a Variable Amount of Information | New Users to Excel | |||
| copy information on a excel sheet and send to an outlook contact? | Excel Discussion (Misc queries) | |||
| How do I copy information and skip hidden cells? | Excel Discussion (Misc queries) | |||
| Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
| Copy and paste Internet information into Excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
