I'm trying to get a summary sheet to work on a workbook with 100 sheets. The formulas need to
look like the following:
=Sheet2!$A$1
=Sheet3!$A$1
=Sheet4!$A$1 ...and so on
but when I try to copy the first formula down it doesn't add the following sheet number. It
ends up as:
=Sheet2!$A$1
=Sheet2!$A$1
=Sheet2!$A$1 ...the same formula repeated
Any ideas on how to copy the formula down? (using Excel 97)
Cheers
co
look like the following:
=Sheet2!$A$1
=Sheet3!$A$1
=Sheet4!$A$1 ...and so on
but when I try to copy the first formula down it doesn't add the following sheet number. It
ends up as:
=Sheet2!$A$1
=Sheet2!$A$1
=Sheet2!$A$1 ...the same formula repeated
Any ideas on how to copy the formula down? (using Excel 97)
Cheers
co