Fill rows in one sheet depending on what is written on a certain cell based on info in another sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1798856%22%20slang%3D%22en-US%22%3EFill%20rows%20in%20one%20sheet%20depending%20on%20what%20is%20written%20on%20a%20certain%20cell%20based%20on%20info%20in%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1798856%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20struggling%20to%20make%20a%20sheet%20work%20as%20I%20intend.%20I%20have%20various%20sheets%20in%20a%20file%20where%20the%20first%20one%20is%20like%20a%20database%20of%20quite%20a%20few%20components%20and%20the%20other%20sheets%20are%20groups%20of%20components%20that%20create%20a%20product%20we%20sell.%20See%20example%20attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20thing%20I%20want%20to%20do%20is%20if%20I%20fill%20a%20cell%20in%20the%20product%20sheet%2C%20in%20this%20case%20would%20be%20%22internal%20description%22%2C%20the%20other%20cells%20are%20filled%20automatically.%20That%20way%2C%20I%20think%2C%20if%20I%20change%20something%20in%20the%20database%20it%20will%20be%20automatically%20changed%20in%20the%20product%20sheet%20(price%2C%20ref%2C...)%2C%20right%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20I'm%20being%20clear%20enough.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1798856%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%202019%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi there,

 

I'm struggling to make a sheet work as I intend. I have various sheets in a file where the first one is like a database of quite a few components and the other sheets are groups of components that create a product we sell. See example attached.

 

The thing I want to do is if I fill a cell in the product sheet, in this case would be "internal description", the other cells are filled automatically. That way, I think, if I change something in the database it will be automatically changed in the product sheet (price, ref,...), right?

 

I hope I'm being clear enough.

 

Thanks in advance!

0 Replies