Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically paste cells that return a value, otherwise maintain existing formula.
I currently recieve data dumps from various instruments runs that I
want to transfer into a master xls file. As the data varies from run to run, I have a master file that contains all the possibilities. I use look ups to put these runs in the right space in the master which works okay. I want some sort of function that automatically pastes the value (like paste special) if the cell returns a value, otherwise if it doesn't i want it to maintain the existing formula. Any Ideas as to how to do this? Cameron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to maintain a set range of cells when dragging a formula (e.gmonthlyannual data) | Excel Discussion (Misc queries) | |||
In-Doc Hyperlink ANSWER maintain lines from Cut-Paste | Excel Discussion (Misc queries) | |||
Can inserted rows automatically include existing worksheet formula | Excel Discussion (Misc queries) | |||
The Excel cells are not automatically calc. existing formula. | Excel Worksheet Functions | |||
Paste and automatically move cells | Excel Discussion (Misc queries) |