Dear All
I am creating a menu costing work book in Micrsoft excel 2007. People will be using the workbook who are a lot more excel iliterate than me.
On the first worksheet I have a list of all the products/raw materials, unit weights, delivery cotainer type, yield percentages, portion size and the most importnat figure of all price per portion.
I would like to create a separate worksheet for each of the menu items, and to make life as simple as possible choose, from a drop down menu, a number of raw materials that make-up the menu item and at the same time insert the price per portion figure from the first worksheet. However, I don't want the whole row from the first worksheet, just the raw material and the price per portion.
Perhaps someone can help, or even suggest a more efficient way of doing this.
Thanks in advance
Red Socks
I am creating a menu costing work book in Micrsoft excel 2007. People will be using the workbook who are a lot more excel iliterate than me.
On the first worksheet I have a list of all the products/raw materials, unit weights, delivery cotainer type, yield percentages, portion size and the most importnat figure of all price per portion.
I would like to create a separate worksheet for each of the menu items, and to make life as simple as possible choose, from a drop down menu, a number of raw materials that make-up the menu item and at the same time insert the price per portion figure from the first worksheet. However, I don't want the whole row from the first worksheet, just the raw material and the price per portion.
Perhaps someone can help, or even suggest a more efficient way of doing this.
Thanks in advance
Red Socks