Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Borders that move when i drag and drop contents | Excel Discussion (Misc queries) | |||
Use Contents of Drop Down List | Excel Programming | |||
Can the contents of a drop down box differ from what's entered? | Excel Worksheet Functions | |||
enlarge drop-down contents | Excel Discussion (Misc queries) | |||
Drop Down Lists - Not allowing other contents to be put in same ce | Excel Worksheet Functions |