I have a spreadsheet with parts and costs for the products we use and
sell (parts list). I have a couple of others that, daily, I have to
input information that is already on the parts list.
Is there a way to put a drop down box in my worksheets, that would pick
up information from our parts list? If so, can I fill in more than one
cell at a time this way?
For example: I have to enter all of the parts we use on a given invoice.
If it were possible I'd like to click on a drop down box, and navigate
to the item, and upon clicking it, have that cell filled in with the
part description. This would be really useful if it would be able to
pull the price into another cell, where I can have it calculate based on
yet another cell (qty) used.
Or, is this too much to ask from Excel?
I appreciate your help, experience, and knowledge!