How to insert a row and not update existing formulas?
I have cells containing references to cells in otherworksheets, ie.
=Sheet1!F12. If I enter a row above this it automatically becomes =Sheet1!F13. How can I prevent this? Please explain in simple terms for a simple man! |
How to insert a row and not update existing formulas?
=INDIRECT("Sheet1!F12")
-- David Biddulph "Bobshaw" wrote in message ... I have cells containing references to cells in otherworksheets, ie. =Sheet1!F12. If I enter a row above this it automatically becomes =Sheet1!F13. How can I prevent this? Please explain in simple terms for a simple man! |
How to insert a row and not update existing formulas?
It works! many thanks.
"Bobshaw" wrote: I have cells containing references to cells in otherworksheets, ie. =Sheet1!F12. If I enter a row above this it automatically becomes =Sheet1!F13. How can I prevent this? Please explain in simple terms for a simple man! |
All times are GMT +1. The time now is 08:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com