Posts by Kevin Boddington

Re: Prevent cell references from updating

Brilliant: You are wonderful, I knew it must be simple but no one at the University I work for seemed to know how to solve this little dilemma.

Thanks for your help.

Kevin

I have a series of worksheets, named, 'sheet1' 'sheet2' etc. through to 'sheet10'. A final worksheet, 'sheet11' has been produced that uses the formula: address=Sheet1!A1, address=Sheet2!A1, address =Sheet3!A1 etc.
The same goes for other identical cells on each of the sheets.
I am at the moment entering each cell on 'sheet 11' separately because if I copy the formula down it progressively changes the cell value and not the sheet number.

How can I produce a formula whereby the cells remain identical but the sheets change progressively?