Mike,

Here's how you can adapt the INDIRECT suggestion to suit ..

In sheet named: 28day report,
Put in the top/starting cell, ie in H41:
=INDIRECT("'payroll entry'!AI"&ROW(A1)*3-3+335)
Copy H41 down to return as required

The expression: ROW(A1)*3-3
will create a simple number series: 0,3,6,9... as the formula is copied down
while the "+335" is an arithmetic adjustment since the start cell in
'payroll entry' is in row 335

(The expression in H41 is left intentionally unsimplified for easier
understanding)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Michael E. Gibson" wrote in message
m...

Bernie,
I thought I could modify the Index and Indirect to work, but I can't. They
work fine on a new work sheet.
I should have explained further.
I am trying to move data from sheet named 'payroll entry' AI335, AI338,
AI341, etc to sheet named '28day report' H41, H42, H43, etc (AI334,AI337,
AI
340 etc, holds data used for another field in the '28day report', and
AI333
, AI336 and so on are used as text fields for headers for the items below
them)
Any Ideas
Thanks
Mike