Excel 2007 : Referencing a cell on another page

**the_ghost** · 08-07-2009, 09:59 AM

I have a workbook in Excel 2007 with a summary page. On the summary page I reference cells from other worksheets in the workbook - example"='05T'!B10". The only problem is that the formula for the reference will change if the referenced cell moves in the other sheet when a line is inserted above it. The formula will now be "='05T'!B11" instead of "='05T'!B10". This is good for some things but I need it to remain unchanged even if a line is inserted in the other sheet above the referenced cell. I have tried using dollar signs before the B and the 10. That did not seem to help.

Is there some way to reference the Column and Row address instead of the cell??

Thanks,

Jason