SOLVED

# Auto fill formula

Occasional Contributor

# 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

Thanks a lot.

9 Replies

# Betreff: Auto fill formula

Unfortunately, it's not that self-explanatory.
I who know nothing can not understand.

Auto fill formula from the columns of sheet 2 to the rows of sheet 1
from which columns? from sheet two
Anyway, I'm confused ... please explain in as much detail as possible, based on your inserted file.

Thank you for your understanding and patience

Nikolino

I know I don't know anything (Socrates)

# Re: Auto fill formula

@Oliullah Offering you a formula that does what you ask for. Though I'm not convinced that this what you really need. am assuming that Product A = 10kg, Product B = 15kg etc.

Perhaps you want to reconsider the structure of the data in sheet 2, as proposed in the green shaded area. See attached.

best response confirmed by Oliullah (Occasional Contributor)
Solution

# Re: Auto fill formula

Formula here

could be

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

# Re: Auto fill formula

@Riny_van_Eekelen , missed your post, actually the same

# Re: Auto fill formula

@Sergei Baklan  Thanks a lot.

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.

# Betreff: Auto fill formula

Thanks. I should have been more explanatory.

I must keep in mind your valuable suggestions.

# Re: Auto fill formula

Actually, I am searching auto fill formula Vertically from Horizontal reference.

Thank you for your valuable time.

# Re: Auto fill formula

``=INDEX(TRANSPOSE('Sheet 2'!\$K\$63:\$FP\$63),(ROW()-ROW(\$D\$12))*3)``