Auto filling formula

[Skibee]

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

 

[Jacob Skaria]

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]

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]

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]

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]

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]

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