Automatically Fill out the cell.

Dear Sir/Madam,

I have encounter a problem using the Excel, I have given an assignment to do, I have been asked to use the Excel to help the assembler of the product to know exactly what are the parts required for a certain product. So, the question would be like, when the user or the assembler type the name of the product for example (iphone X) the excel should automatically list down the parts of the iphone in such way,

                Product Name: iPhone X



1.     Front cover.

2.     Back Cover

3.     Li Battery 

4.     Touch Screen

5.     Volume Buttons

6.     …. etc 

So, when the user types the name of the product the parts should appear automatically.

Thank you I hope that I make myself clear.


Thank you,


By: Hassan

Leave a Reply

Your email address will not be published. Required fields are marked *