Just revised the formula to be used in any row...

If first formula is pasted in J10

J10 ='All Data'!B6
Enter the below formula in J11 . Please note that cell J10 is referred in
the formula. Basically you need to refer the first formula cell in the second
formula....and then copy the formula down...

=INDIRECT(ADDRESS(ROW()-(ROW($J$10))+1,ROW()-(ROW($J$10))+1))+'All Data'!B7

If this post helps click Yes
---------------
Jacob Skaria


"Skibee" wrote:

Hi
I have lots of formulas to enter following a similar pattern - can I auto
enter them. The pattern is as follows

='All Data'!B6,
=B2+'All Data'!B7
=C3+'All Data'!B8
=D4+'All Data'!B9

Any help much appreciated as I have eight sets of these to do, each with 52
entries!

Many Thanks