Try this in Row 1 of any column suppose

J1 ='All Data'!B6

Enter the below formula in J2 and drag down
= INDIRECT(ADDRESS(ROW(),COLUMN()-COLUMN()+ROW()))++'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