Forum Discussion

Copper Contributor

Mar 04, 2021

Solved

Auto fill formula

Hello, The attached file is self explanatory. I badly need a formula in Column C of sheet 1. Auto fill Formula from the columns of sheet 2 to the rows of sheet 1 Please help me. Than...

Auto fill Formula.xlsx10 KB

excel

Formulas and Functions

SergeiBaklan
Mar 04, 2021
Oliullah

Formula here

could be

=INDEX(Sheet2!$3:$3, (ROW()-ROW($B$1))*3)
Auto fill Formula.xlsx13 KB

SergeiBaklan

Diamond Contributor

Mar 04, 2021

Oliullah

Formula here

could be

=INDEX(Sheet2!$3:$3, (ROW()-ROW($B$1))*3)

Auto fill Formula.xlsx13 KB

Oliullah
Copper Contributor
Mar 05, 2021
SergeiBaklan Thanks a lot.

Please help me with the attached file.

In sheet 1, Column D, I have manually linked the cell reference from Sheet 2.
And in Sheet 1 , Cell E13, Cell F13, Cell G13, Cell H13, Cell I13 I have manually linked the cell reference from Sheet 2.

Now, I need your magical formula in Sheet 1 (Column D, Column E, Column F, Column G, Column H, Column I)

Thanks again.
Auto fill.xlsx4.3 MB
- SergeiBaklan
  Diamond Contributor
  Mar 05, 2021
  Oliullah
  
  Please check in column AF
  
  =INDEX(TRANSPOSE('Sheet 2'!$K$63:$FP$63),(ROW()-ROW($D$12))*3)
  
  Auto fill.xlsx4.1 MB
  - Oliullah
    Copper Contributor
    Mar 06, 2021
    Thanks.
    
    Trying the formula.