One way ..
Put this in the starting cell:
=INDIRECT("'By Name'!A"&ROW(A1)*3-1)
Copy down as far as required
The above will return the required results, ie same as:
='By Name'!A2
='By Name'!A5
='By Name'!A8
etc
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"CJWilson" wrote:
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.