| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace old sheet with new without losing formula ref
Is is possible to retain the formula or rather the ref in one sheet to
other sheet,when the other sheet are replaced by new sheets with updated data. Say I have sheet one with formula ref to sheet 2 named :"TEST". This sheet is to be replaced with updated data and hence has to replaced .Now To name it text i have to delete the old test. Or I have to name it something else. In which case the formula would only refer to old data Help welcome for a solution. sbaloo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to replace sheet name in a formula? | Excel Worksheet Functions | |||
| Losing calculations when deleting a sheet | Excel Programming | |||
| trying to find #REF! in a formula to replace with a sheet name | Excel Programming | |||
| replace formula references with previous sheet names | Excel Programming | |||
| Modifying many cells with find/replace without losing unique data. pls help | Excel Programming | |||
Linear Mode
