I have an excel document with a number of worksheets in it. The last of these worksheets performs calculations on the worksheest before it. It is a bit like a summary sheet of all the data in the worksheets before it.

The problem that i have is as follows

The first worksheet is called enquiries
The last worksheet i have is called Summary.

The summary worksheet pulls information from the enquiries worksheet as follows =enquiries!H7

However when a change is made to the enquiries sheet for example a new row added or a row deleted rather than the formula on the summary sheet remaining as =enquiries!H7 it will change to something like =enquiries!#REF! or will jump dramatically to read =enquiries!H123

I need to lock the range of cells that my formulas work on if possible. My colleague has suggested the use of the $ sign i.e. =enquiries!$H$7 This appeared to work but when i tried to do fill down all the cells i filled down on had the same formula.

Any ideas would be a great help.

Sorry for the sketchy description but its kinda hard to describe the problem.

Many thanks

Andy