Forum Discussion
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.
Thanks a lot.
9 Replies
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.
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.
- Thanks. Your table is correct.
Actually, I am searching auto fill formula Vertically from Horizontal reference.
Thank you for your valuable time. Riny_van_Eekelen , missed your post, actually the same
- 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
Should these be added up?
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)- Thanks. I should have been more explanatory.
I must keep in mind your valuable suggestions.
Thank you for your patience.
