Search and select from Drop down list or sheet of Database

[jack999]

http://www58.zippyshare.com/v/11241576/file.html

Sample excel copy link above


I have more than 200 Customer Name in Database sheet.

I want to search select Customer Name from sheet name Database in the sheet of Invoice-Cash-Cheque sheet at the bottom row for data entry.

I would like to search and select it for data entry at bottom row of Invoice-Cash-Cheque sheet, how it possible. Can we make search in Drop down List with 3-4 starting Characters of the customer name?

Can it do with the help of macro?

 

[Smallman]

Hi Jack


I can't open your file at this stage. However what you are describing is an Auto Complete feature. There is a tutorial and a working example on at the following page;


http://www.contextures.com/xlDataVal10.html


Hope this helps.


Smallman

 

[jack999]

http://www46.zippyshare.com/v/39105554/file.html

Link is above

 

[jack999]

I want to add data to the last empty row

 

[SirJB7]

Hi, jack999!

If I'm not missing or misreading something the data contained in the 3 worksheets Database, Invoice-Cash-Cheque and requirment is not congruent, i.e., it doesn't reflect an actual case for a given account and its movements. Would you please upload a sample file rectifying that? Thank you.

Regards!

 

[jack999]

Sir I solved the problem. Thanks