Hi,

I'm creating a multisheet spreadsheet where I need to keep the number
reference constant.

Example of formulae:

=+'A Sheets'!H18

I want the cell letter to increase but the number to remain constant. So
copying down the spreadsheet the next reference would be:

=+'A Sheets'!I18 then =+'A Sheets'J18 etc. etc.

I've tried using '$' but to no avail.

Thanks in advance.

Sean.





--
It's time to burn........