Assuming this formula is entered into cell A1:
=INDEX(Timesheets!L$67:L$500,(ROWS(A$1:A1)-1)*50+1)

Change (Rows(A$1:A1)) to whatever the cell address you actually enter the
formula into. Also change Timesheets!L$67:L$500 to whatever the actual range
is.



"Steve" wrote:

I have a large spreadsheet over several pages and i am crossreferencing the
pages.

I want to point to a cell on a previous sheets which i can do but!!! i have
about 70 rows to do this on and wonder if there is anyway of copying the
formulea down. I know you can click on the bottom right and drag but the
problem is the cells in the previous page have gaps in them

e.g.
timesheets!L67
timesheets!l117
timesheets!167
they are 50 rows apart and i want the info from that sheet pulling through
onto the one i am working on

I can do it long hand but i have hundreds to do and i am hoping there is an
esy way??