use combo box to load customers details fromone sheet in to anothe

B

BinaH57

Dear Excel Gurus,

I am a bigginer in excel and neet to do th following:

I have two sheet in a workbook. One sheet contains 8 columns and 254 rows of
customers details such as Name; Address,tel:etc

The otherr sheet in a form part of which is a section to fill in customers
details. I need to have a combo box to display all the customers in the
second sheet and to allow me to extract any partecular details in to the
Customere;s section of the form on the other sheet.

I ahve tried inserting the combo and define the range in the other sheet but
can not popuilate all the relevenat fields.

I am grateful for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Iterating the combo box and displaying the value after each change onseprate sheet. 2
how to use Combo box to lookup and retrieve customers details 5
Advice on creating custom excel program 0
V Lookup using a combo box in Excel 2003 0
Combo Boxes getting data from Work Sheet. 4
copy data from one sheet to another using a combo box 1
Resize Detail Section in Form 2
Combo box - Unique values without blanks. 1

Top