Hey guys,
I've been trying to figure out a way how to be able to have a drop down menu that consists of "grouped items" i.e. items that fall under the same group/category; and once a group item/category has been selected, the individual items need to be automatically copied down on separate rows.
I've attached my excel file consisting of two tabs: an item list and an estimate template. On the item list, you can see that column B designated as "Group Name" consists of several individual item names and also a "subtotal" item that needs to calculate the total price for that particular group name. My goal is to be able to formulate a way (either by a drop down list, data validation, or userform) to be able to select "Group Name" under the "Estimate" tab and then have all of its individual items as well as the subtotal pasted one after the other. I would also consider using check boxes to select group names.
Any help or guidance on this would be highly appreciated,
Thank you.
Example.xlsx
Bookmarks