| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieve Formula Result when Saving
I want to be able to take the last value in a column on Sheet 2 and display
it in another spreadsheet(Sheet 1) in cell A1 whenever someone saves the workbook. The cell I want to copy contains a formula which displays the calculated result and if a value isn't calculated the cells display nothing. I would like to only take the last cell in column B that has a value. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I closed an excel file without saving the changes. Can I retrieve | Excel Discussion (Misc queries) | |||
| Saving A One Off IF Result | Excel Worksheet Functions | |||
| Retrieve result of query from Access | Excel Programming | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| How can I retrieve a file that was closed without saving? | Excel Discussion (Misc queries) | |||
Threaded Mode
