I have a summary sheet which contains multiple recipes for multiple items. The sheet is structured as such:
Parent item Component item # Qty required
Item # 1 Component # 1 0.5
Item # 1 Component # 12 6
.....
Item # 26 Component # 3 12
Item # 26 Component # 1 2
I'd like to create a summary sheet that will pull from my data sheet and allow me to present the recipe for a particular item (and only that item) when I select the desired item # from a drop down list.
The recipes can have different numbers of components so I need the summary to be flexible enough to handle this.
Any ideas would be greatly appreciated.
Parent item Component item # Qty required
Item # 1 Component # 1 0.5
Item # 1 Component # 12 6
.....
Item # 26 Component # 3 12
Item # 26 Component # 1 2
I'd like to create a summary sheet that will pull from my data sheet and allow me to present the recipe for a particular item (and only that item) when I select the desired item # from a drop down list.
The recipes can have different numbers of components so I need the summary to be flexible enough to handle this.
Any ideas would be greatly appreciated.