Drop down box w/contents of different worksheet? is this possible
 

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!

Drop down box w/contents of different worksheet? is this possible
 

Oddjob007 wrote on 5/15/2012 :
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!

Yes, it's possible..BUT...

Seems to me it would be easier to have your invoicing app output
directly to Excel because it sounds like you're trying to duplicate the
data record for invoices.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion