I was wondering if there was a way to create a pop-up list to appear when a user selects a certain cell that would provide the user with a list of (in this particular case) inventory items. The user would select which items they require for the task at hand and the total $$cost of the items would appear in the cell once is is deselected.
I'm not sure if a userform would be the correct item for this, or if this idea is even plausible.
Thanks for any help
Jimbean