Choosing which pattern to follow when extending a column of data

[tangfastic1]

Good morning/Afternoon/Evening

I have a large spreadsheet and I want to create another page that references data on 90 other pages within the spreadsheet.

The formula currently looks like this:
='18'!G35
='19'!G35
='20'!G35
='21'!G35
='22'!G35

I've typed out this formula to 5 rows in a column and everytime I try and extend it, I get the following:

='18'!G35
='19'!G35
='20'!G35
='21'!G35
='22'!G35
='18'!G40
='19'!G40
='20'!G40
='21'!G40
='22'!G40

And instead I would like it to do the following:

='18'!G35
='19'!G35
='20'!G35
='21'!G35
='22'!G35
='23'!G35
='24'!G35
='25'!G35
='26'!G35
='27'!G35

I am using Office 2010 by the way.

I'm sure I am missing something obvious!

Thanks

[Pete_UK]

Put this in your first cell:

Please Login or Register  to view this content.

then copy down.

Hope this helps.

Pete

[tangfastic1]

Excellent, many thanks Pete, worked perfectly