Hi I'm creating a spreadsheet to keep track of my costs of production in an online game. Within the game there are a range of spawned resources that appear for only a short time before being unobtainable these resources have specific types that is shared between multiple spawns of the resource but each resource spawn has a unique name.
My first worksheet lists all the resources and their various qualities and the later worksheets are meant to allow me to choose from a list resources matching the requirements of the item I'm looking to craft. The example i have shown in the second picture requires Tatooinian Fiberplast and Lokian Wild Wheat to craft so in the Chosen Resource column I would like to have a drop down list allowing me to select the named resource type i would like to use - for Tatooinian Fiberplast the only thing on the list should be Omnitwixi and for the Wild Wheat it should show Fizi and Krad
http://i.imgur.com/9ju5Tnv.png
http://i.imgur.com/pTuvDQN.png
I am aware there are people with more pressing problems than computer games and as such I understand if you aren't willing to take the time to help but any time you can spare to help me out would be greatly appreciated
Thanks again
CraftyGamer
Bookmarks