| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Solution Required to prevent #Ref! when rows deleted
Hi All,
I have a spreadsheet where on sheet 1 I have some data and in sheet 2 I have a template that uses simple =Sheet1!A1 formulas. The problem I have is that if I delete row A on sheet 1, the formula on sheet 2 that used to say =Sheet1!A1 turns to =Sheet1!'REF! How do I change this so that I can happily delete rows from Sheet 1 without messing up my template. I have tried making the formulas absolute and this doesn't work? Any suggestions?????? Ta Andi |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
| how do i prevent a #REF! error when i delete non adjacent rows? | Excel Worksheet Functions | |||
| REALLY miussing rows in Excel2000 | Excel Discussion (Misc queries) | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
| Adding Rows to Master Sheet | New Users to Excel | |||
Threaded Mode
