Auto filling formula
 

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

Auto filling formula
 

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

Auto filling formula
 

Oops, in J2 enter the below formula..If you are not starting from Row1 adjust
the formula by substracting the

=INDIRECT(ADDRESS(ROW(),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

Auto filling formula
 

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