Hi, I am a jewelry maker and I would like to create an Excel spreadsheet to make my production tasks easier. I am by no means an Excel expert. I can follow a tutorial if I knnow what I need to do but because I am no expert I don't always know the best route to get something done.
I have a spreadsheet that lists my base product line, each piece is made up of several components. What I would like to do is select a product, select the qty I need to make and the color and have it return the number of each individual component I need to make that qty of items.
Ex. Blue Stone Necklace
Qty: 2
Return Components:
25 small blue stones
50 small white stones
100 small silver beads
1 large green focal.
In addition, I would like to be able to pull this information simultaneously for other items and have it calculate the complete total.
For example in addition to the 2 blue necklaces I also want to make 5 red necklaces that use some of the same blue stones and silver beads. I would like for the spreadsheet to also be able to tell me the total of all silver beads and blue stones needed for the 7 necklaces.
Is this even possible?
Thanks in advance!
Bookmarks