I am creating a price list that contains multiple items in different combinations, for example I have multiple parts that can be sold separately or in a system.
I would like to have a section in the price list that combines a number of parts to create a complete system and get the final price. I have been able to create lists using data validation and name Manager but after that I get lost.
Example:
A26 contains a list of 4 options which are located in A6:A9. A6 is the product name, b6 is the product code, c6 is the MSRP etc... all the way to H6. What I would like is that when A6 is selected from this drop down menu in A26 I would like the adjacent cells to the right of A26 to automatically be filled in with the contents from A6 through H6 so that when I am making a customized system I can chose the products I need and have the prices imputed automatically instead of adding them all up separately.
I have attached a sample price list with what I am trying to accomplish. My understanding of excel formulas is pretty basic so please don't take anything for granted when explaining.
Help is very much appreciated and look forward to hearing some suggestions.
Thank you very much.
Bookmarks