I want to be able to copy the following formula sequence down an excel sheet:
='By Name'!A2
='By Name'!A5
='By Name'!A8
....
But excel will not recognise the sequence. Can I
a) Do something so it will recognise it and copy it
or
b) Make the cell references the result of a formula e.g. ='By Name'!A(B1),
where B1 contains the reference I need.