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

[Oddjob007]

I have a spreadsheet with parts and costs for the products we use an
sell (parts list). I have a couple of others that, daily, I have t
input information that is already on the parts list.

Is there a way to put a drop down box in my worksheets, that would pic
up information from our parts list? If so, can I fill in more than on
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 navigat
to the item, and upon clicking it, have that cell filled in with th
part description. This would be really useful if it would be able t
pull the price into another cell, where I can have it calculate based o
yet another cell (qty) used.

Or, is this too much to ask from Excel?

I appreciate your help, experience, and knowledge

 

[GS]

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