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