Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to use Combo box to lookup and retrieve customers details
Please give me some clue.
I have a sales invoice form on sheet1. All customers details such as name;surname;etc are in sheet2. Can I use a combo box to retrive customers details from the other sheet in to the form on sheet1? short of this I have to type all details for every invoice I need to issue. Many thanks for your help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to use Combo box to lookup and retrieve customers details
1) Use data Validation to control Sheet1 data entry.
http://www.contextures.com/xlDataVal01.html NOTE WELL: Naming ranges makes data validation work between different sheets. 2) Use Vlookup to return values from Sheet2 based on valued entered in Sheet1 http://www.contextures.com/xlFunctions02.html -- Steve "BinaH57" wrote in message ... Please give me some clue. I have a sales invoice form on sheet1. All customers details such as name;surname;etc are in sheet2. Can I use a combo box to retrive customers details from the other sheet in to the form on sheet1? short of this I have to type all details for every invoice I need to issue. Many thanks for your help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to use Combo box to lookup and retrieve customers details
Thanks ever so much.
However having done that it seems that I am only bound by the data in the list. Is there a way I can also entre/type data that is NOT in the defined list? i.e a new customer whjos details in not already entred. "AltaEgo" wrote: 1) Use data Validation to control Sheet1 data entry. http://www.contextures.com/xlDataVal01.html NOTE WELL: Naming ranges makes data validation work between different sheets. 2) Use Vlookup to return values from Sheet2 based on valued entered in Sheet1 http://www.contextures.com/xlFunctions02.html -- Steve "BinaH57" wrote in message ... Please give me some clue. I have a sales invoice form on sheet1. All customers details such as name;surname;etc are in sheet2. Can I use a combo box to retrive customers details from the other sheet in to the form on sheet1? short of this I have to type all details for every invoice I need to issue. Many thanks for your help |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to use Combo box to lookup and retrieve customers details
a. Remove the DV for that particular cell (most obvious way?), or,
b. Try using dynamic ranges for the DVs to auto-expand the list in the dropdown for any new items. See Debra's notes at: http://www.contextures.com/xlNames01.html#Dynamic -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "BinaH57" wrote: However having done that it seems that I am only bound by the data in the list. Is there a way I can also enter/type data that is NOT in the defined list? i.e a new customer whose details are not already entered. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to use Combo box to lookup and retrieve customers details
Thank you very much indeed. all sorted.
Regards, Bina "Max" wrote: a. Remove the DV for that particular cell (most obvious way?), or, b. Try using dynamic ranges for the DVs to auto-expand the list in the dropdown for any new items. See Debra's notes at: http://www.contextures.com/xlNames01.html#Dynamic -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "BinaH57" wrote: However having done that it seems that I am only bound by the data in the list. Is there a way I can also enter/type data that is NOT in the defined list? i.e a new customer whose details are not already entered. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to use Combo box to lookup and retrieve customers details
Welcome, glad to hear
-- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "BinaH57" wrote in message ... Thank you very much indeed. all sorted. Regards, Bina |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to use the lookup function to retrieve objects? | Excel Discussion (Misc queries) | |||
I NEED TO USE A LOOKUP FUNCT. TO RETRIEVE A PICTURE FROM A HYPERL | Excel Worksheet Functions | |||
How do I retrieve message details like the sender name into Excel | Excel Discussion (Misc queries) | |||
How to use lookup to retrieve next LARGEST value? | Excel Worksheet Functions | |||
need to retrieve dates from lookup | Excel Discussion (Misc queries) |