shadowmeister
New Member
- Joined
- Jan 13, 2014
- Messages
- 2
Good morning all,
First post here. Let me cut straight to the chase.
I am trying to create a monthly menu on one worksheet and an inventory stock holdings on another sheet. what i would like to do is whenever a menu item is added to the monthly menu, certain items are deducted from the inventory stock holdings. here is an example;
On Wednesday 15th January i plan on cooking steak fried rice. the ingredients i want to deduct from the stock holdings are:
Steak x 2, Rice x 1, Peas x 1, Onion x 2.
The ingredients are listed similar to the table below on worksheet 2:
<tbody>
</tbody>
I have no clue what formular to use if any, something along the lines of steak fried rice = (Steak x 2, Rice x 1, Peas x 1, Onion x 2).
i do not have that much experience with excel, and was hoping you experts could help.
Regards,
Shadowmeister.
First post here. Let me cut straight to the chase.
I am trying to create a monthly menu on one worksheet and an inventory stock holdings on another sheet. what i would like to do is whenever a menu item is added to the monthly menu, certain items are deducted from the inventory stock holdings. here is an example;
On Wednesday 15th January i plan on cooking steak fried rice. the ingredients i want to deduct from the stock holdings are:
Steak x 2, Rice x 1, Peas x 1, Onion x 2.
The ingredients are listed similar to the table below on worksheet 2:
| Food Item | Qty |
| Steak | 2 |
| Rice | 1 |
| Peas | 1 |
| Onion | 2 |
<tbody>
</tbody>
I have no clue what formular to use if any, something along the lines of steak fried rice = (Steak x 2, Rice x 1, Peas x 1, Onion x 2).
i do not have that much experience with excel, and was hoping you experts could help.
Regards,
Shadowmeister.
