| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Move data - what happens to formula's
Yes it will affect your formulae. When you cut the source data that is
refered in the formula and paste it elsewhere your formula may Show #REF!, which means your references are missing. It may not happen for simple formulae as excel adjusts the references to the new place of the data. But if you do see #REF! appearing in your formulae then all you have to do is go to your formulae and edit the #REF! with the new cell ranges. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I move this data? | New Users to Excel | |||
| Inserting rows with Data, Formula's and Validation | Excel Discussion (Misc queries) | |||
| Keeping data without losing Formula's | Excel Discussion (Misc queries) | |||
| Macro to move data to different column based on data in another co | Excel Discussion (Misc queries) | |||
| enter data in cell which will start macro to move data to sheet2 | Excel Discussion (Misc queries) | |||
![AG[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
