In Progress

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.

Skills: Excel

See more: excel dynamic drop, dynamic dependent subcategory excel, excel drop box, excel dynamic drop box, excel spreadsheet formula, box, excel formula spreadsheet spreadsheet, drop list database, populate excel spreadsheet spreadsheet, 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, formula add list excel spreadsheet, drop list selection, dynamic dependent drop

About the Employer:
( 3 reviews ) Mosman, Australia

Project ID: #1707241

Awarded to:

raman2012

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

$30 AUD in 1 day
(1 Review)
1.3

18 freelancers are bidding on average $58 for this job

bharanisrihari

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

$60 AUD in 1 day
(59 Reviews)
6.3
vserv

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

$30 AUD in 1 day
(56 Reviews)
5.6
nagybatonyi

Please, see PMB for a sample solution! Regards

$60 AUD in 0 days
(44 Reviews)
5.6
Krusche

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

$60 AUD in 1 day
(21 Reviews)
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 More

$75 AUD in 2 days
(21 Reviews)
4.9
chriskerpini

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

$60 AUD in 1 day
(12 Reviews)
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 in 1 day
(10 Reviews)
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 in 1 day
(14 Reviews)
3.9
JayMyers

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

$65 AUD in 1 day
(1 Review)
1.8
Bhawani14solanki

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

$30 AUD in 0 days
(0 Reviews)
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 in 1 day
(0 Reviews)
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 More

$100 AUD in 1 day
(1 Review)
1.8
ksrslm

Will provide accurate Excel file with dropdown box

$120 AUD in 7 days
(0 Reviews)
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 in 1 day
(0 Reviews)
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 More

$30 AUD in 1 day
(0 Reviews)
0.0
najeebmohammed

I can do this work

$100 AUD in 2 days
(0 Reviews)
0.0
ExcelVBA1

please check PM

$30 AUD in 1 day
(0 Reviews)
0.0
IndoMale

I completely understand what you expect. Thank you.

$30 AUD in 3 days
(0 Reviews)
0.0