How to change preset values of a row by selecting from a dropdown list
I am pretty new to Excel but need to make an Excel sheet where I can select the item name so when the selected item changes so do all the values (price) of the column. Once this changes the value when I enter quantity, it would calculate the cost.
I do have this working in 20 different sheets but I want to able to make this work in only one sheet.
Note: Each selected item has about 100 different sub items and that's why I need drop list to override columns with preset values.
How should I approach this?
Edit not by OP to add image from link provided in comment
I am pretty new to Excel but need to make an Excel sheet where I can select the item name so when the selected item changes so do all the values (price) of the column. Once this changes the value when I enter quantity, it would calculate the cost.
I do have this working in 20 different sheets but I want to able to make this work in only one sheet.
Note: Each selected item has about 100 different sub items and that's why I need drop list to override columns with preset values.
How should I approach this?
Edit not by OP to add image from link provided in comment
No comments:
Post a Comment