Devam Ediyor

Pop Find and Select item to insert

I have an excel sheet that uses a drop down menu in column D to select an account name. Once the account name is select then the adjacent cell (column D) looks up the appropriate distribution from another worksheet. The problem that I have is that there are about 2,000 distributions to search through in the drop down list in column D. What I'd like to be able to do is click on the cell in column D and have the Find window pop up like when you click Ctrl + F. I'd then like to search the list on the other worksheet using a keyword or multiple keywords. Once that is done then I'd like to be able to select one of the items from the list and have it input into column D which would in turn look up the appropriate distribution for column E. Is this possible in excel?

I've attached the excel sheet so you can see what I'm working with.

Beceriler: Excel, Visual Basic

Daha fazlasını görün: excel find select, keyword find, uses for excel, excel uses, select, select item from, d to, window excel 2013, 2013 excel visual basic, excel 2013 visual, excel search multiple keywords, select drop, multiple keywords excel, excel window, visual basic excel 2013, excel search keywords, drop menu excel, excel drop, excel 2013 visual basic, select name, name select, account list item, find multiple, item list, select select

İşveren Hakkında:
( 2 değerlendirme ) ALPINE, United States

Proje NO: #4422071

Seçilen:

vserv

Excel expert. Definitely possible. Please see your messages. Thanks

1 gün içinde 35$ USD
(63 Değerlendirme)
5.7

10 freelancer bu iş için ortalamada 75$ teklif veriyor

Teloquence

Consider it done. Check your PM for my bid details.

in 3 gün içinde99$ USD
(51 Değerlendirme)
5.2
deepbluetech

What you are looking for is possible in Excel using macros. Let me know.

in 2 gün içinde75$ USD
(82 Değerlendirme)
5.1
binaryromel

##### Excel expert here! Please check PM. #####

in 3 gün içinde82$ USD
(37 Değerlendirme)
4.9
vikashgadia

excel expert would complete the job in record time.

in 2 gün içinde82$ USD
(14 Değerlendirme)
3.5
farr4u

Hi, Its done as per your requirement and additional functionality, plz see pm for full documentation. Regards.

in 0 gün içinde35$ USD
(7 Değerlendirme)
3.0
omaralieissa

Hi, i can make you small C# program which will do this task instead of Excel poor environment, thanks.

in 3 gün içinde100$ USD
(5 Değerlendirme)
2.9
jeremiahyoder

I am capable of completing this task. Just send me the word and I will get started immediately.

in 3 gün içinde110$ USD
(0 Değerlendirme)
0.0
JorgeRG

Ready to develop your Excel project.

in 7 gün içinde110$ USD
(0 Değerlendirme)
0.0
kimlan20

Yes, It can be done and I am ready for your project. Thanks

in 3 gün içinde66$ USD
(0 Değerlendirme)
0.0
anomanpk

I would like to offer my services for this job.

in 3 gün içinde65$ USD
(0 Değerlendirme)
0.0