Excel spreadsheet (or Google Sheets)- dynamic dependant dropdown required
- or -
Post a project like this2872
$$
- Posted:
- Proposals: 9
- Remote
- #1173665
- Completed
Business Analyst, VBA Programmer, Microsoft Excel Expert, Proofreader, Qlik Sense Data Architect, Qlik Sense Visualisations Expert
Glasgow
MBA Global Business Strategy, Export Bussiness Developement, Study Methods Teacher, Excel Developer, Amateur artist, Seller,
Lima
19347861768395618320827032885239775998857910253271237383
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
(I have re-written this spec. Sorry, following the PPH wizard approach vreated a confusing job. Hopefully this is clearer. Please let me know if you need to change your bid as a result.)
Dependant Dropdown required:
Please see an example of the spreadsheet here - https://drive.google.com/open?id=1h-3Q4_us8dNiC6o6bRVdbNujYX0jSx1alG6hvUObn74
On Renewals Sheet:
Column H (Training Provider)
I have the dropdown showing a combo dropdown list from the 'Provders' sheet (Providers!A2:A1084). This works fine
Column I (Venue)
I currently have a combo dropdown list from the 'Venues' sheet ('Venues Info'!D:D). I would like this changed. I only wish to see addresses associated with the Training Provider selected.
I would like the selection of addresses to be filtered depending on the selection in the cell before, from column H.
EG:
If I select '1 Up Access' as my Training Provider in column H, I would like to see only those addresses that are associated with 1 Up Access (currently in 'Venues Info' sheet D2:D5).
Additional Requirements:
I would need to be able to add and edit new information in the 'Venues Info' sheet and 'Providers' sheet, which would dynamically apend the dropdowns in the 'Renewals' sheet.
I need the formula to carry down the column (Renewals, column I), for every new row.
In Renewals sheet, if Column H is changedafter column I has data in it, I need to see an error or the list reset.
I need to have access to the formula (following payment of course), and an explanation if required. This is is I can copy it from this Development Version across to a live spreadsheet.
I would like this as Google Sheets not Excel please.
Extra if easy:
Display data in the dropdown alphabetically.
Display a default in empty (EG - ' - Select from dropdown - ')
Please do not make changes to this sheet (if you need to play with it, please create a copy first)
Specific technologies required: Excel, scripts, spreadsheets, formulas
Location
Remote OK, but would prefer if someone could come to Maidstone, Kent or close to (could meet).
I know this is pretty straightforward if it's your thing. I have more work for this spreadsheet but wanted to start with one task first.
Thanks very much
Andy
Dependant Dropdown required:
Please see an example of the spreadsheet here - https://drive.google.com/open?id=1h-3Q4_us8dNiC6o6bRVdbNujYX0jSx1alG6hvUObn74
On Renewals Sheet:
Column H (Training Provider)
I have the dropdown showing a combo dropdown list from the 'Provders' sheet (Providers!A2:A1084). This works fine
Column I (Venue)
I currently have a combo dropdown list from the 'Venues' sheet ('Venues Info'!D:D). I would like this changed. I only wish to see addresses associated with the Training Provider selected.
I would like the selection of addresses to be filtered depending on the selection in the cell before, from column H.
EG:
If I select '1 Up Access' as my Training Provider in column H, I would like to see only those addresses that are associated with 1 Up Access (currently in 'Venues Info' sheet D2:D5).
Additional Requirements:
I would need to be able to add and edit new information in the 'Venues Info' sheet and 'Providers' sheet, which would dynamically apend the dropdowns in the 'Renewals' sheet.
I need the formula to carry down the column (Renewals, column I), for every new row.
In Renewals sheet, if Column H is changedafter column I has data in it, I need to see an error or the list reset.
I need to have access to the formula (following payment of course), and an explanation if required. This is is I can copy it from this Development Version across to a live spreadsheet.
I would like this as Google Sheets not Excel please.
Extra if easy:
Display data in the dropdown alphabetically.
Display a default in empty (EG - ' - Select from dropdown - ')
Please do not make changes to this sheet (if you need to play with it, please create a copy first)
Specific technologies required: Excel, scripts, spreadsheets, formulas
Location
Remote OK, but would prefer if someone could come to Maidstone, Kent or close to (could meet).
I know this is pretty straightforward if it's your thing. I have more work for this spreadsheet but wanted to start with one task first.
Thanks very much
Andy
Andy Y.
100% (63)Projects Completed
116
Freelancers worked with
58
Projects awarded
22%
Last project
16 Feb 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Andy, Could you please clarify if you are after an Excel solution to this? Thanks, Tom
1625
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies