Käynnissä

Dynamic dependent drop down box

We need an excel spreadsheet that allows selection of categories from a list of a category and related subcategories. I have investigated and think that it is the creation of an index and match formula to create a dynamic dependent drop down box . There are approximately 44 categories and up to 20 items in each category (defined).

I need to be able to add to the spreadsheet as it is a contact database and we want to be able to pick a category and sub-category for each contact. We need to be able to add to the category / subcategory list going forward and populate the contacts on the excel spreadsheet also.

I have attached a sample of the excel spreadsheet we need to create and a copy of the list we need the drop down box for in word.

Taidot: Excel

Näytä lisää: excel dynamic drop, dynamic dependent subcategory excel, excel drop box, excel dynamic drop box, excel spreadsheet formula, drop list database, excel selection list, dynamic database, formula excel index, excel match formula, pick excel, contacts database excel, create index word, index match formula, populate excel spreadsheet, create selection excel, create excel drop list, dynamic drop list, create contact list excel, drop list selection, dynamic dependent drop, excel drop, formula populate spreadsheet, index excel, dynamic 2012

About the Employer:
( 3 reviews ) Mosman, Australia

Projektin tunnus: #1707241

Myönnetty käyttäjälle:

raman2012

I have finished your project. you can Review and comment.

30 $ AUD 1 päivässä
(1 arvostelu)
1.3

18 freelanceria on tarjonnut keskimäärin 58 $ tähän työhön

bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

60 $ AUD 1 päivässä
(59 arvostelua)
6.3
vserv

Excel expert with 12+ years experience. Please see your messages. Thanks

30 $ AUD 1 päivässä
(56 arvostelua)
5.6
nagybatonyi

Please, see PMB for a sample solution! Regards

60 $ AUD 0 päivässä
(44 arvostelua)
5.6
Krusche

We can do magic with Excel and we would be happy to cover your business need.

60 $ AUD 1 päivässä
(21 arvostelua)
5.2
MDavidCrompton

Hi, I have worked on conversion, manipulation and analysis of Excel for 30 years and have completed several freelancer projects, PLEASE CHECK FEEDBACK. I think the attached about does it. I would like to work on this p Lisää

75 $ AUD 2 päivässä
(21 arvostelua)
4.9
chriskerpini

More than 10 years experience in Excel-VBA. Please check your PMB for details.

60 $ AUD 1 päivässä
(12 arvostelua)
4.4
kulhanekd

I can assist in your project. I have 15 years exp in excel. I can create the drop downs you request. Donna

100 $ AUD 1 päivässä
(10 arvostelua)
4.4
Pichart

I have read your requirement, and have a look at both of your attachments. I do understand your need and can finish within 1 day. More in PM, please.

35 $ AUD 1 päivässä
(14 arvostelua)
3.9
JayMyers

It would be a privilege to accomplish this project for you. Fast turn around time and hassle free.

65 $ AUD 1 päivässä
(1 arvostelu)
1.8
Bhawani14solanki

hi i have an 2 year experience of excel this is quite eassy for me thank's bhawani

30 $ AUD 0 päivässä
(0 arvostelua)
0.0
MaTThZero

I already have a solution for your current needs so check you PMs for a sample and check if it's what you need.

30 $ AUD 1 päivässä
(0 arvostelua)
0.0
Midlander

You should find the attached Excel 2010 sample gives you the Primary and Secondary Category and Sub-Category "dropdowns " you want. Please see the Private Message Board for more details. Now working as a Freelancer Lisää

100 $ AUD 1 päivässä
(1 arvostelu)
1.8
ksrslm

Will provide accurate Excel file with dropdown box

120 $ AUD 7 päivässä
(0 arvostelua)
0.0
Dhavalvimawala

I have the required skills to complete the desired work. I assure you that, if given an opportunity, I will provide high quality service in the desired time frame.

30 $ AUD 1 päivässä
(0 arvostelua)
0.0
permana78

Hello, I am very much interested on your project. I have read your requirements and I am quite confident that I will be able to get your work done within the given time.I am very keen to discuss further. You can reach Lisää

30 $ AUD 1 päivässä
(0 arvostelua)
0.0
najeebmohammed

I can do this work

100 $ AUD 2 päivässä
(0 arvostelua)
0.0
ExcelVBA1

please check PM

30 $ AUD 1 päivässä
(0 arvostelua)
0.0
IndoMale

I completely understand what you expect. Thank you.

30 $ AUD 3 päivässä
(0 arvostelua)
0.0