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

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

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

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.

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.

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