Google Scripts Code for Dynamic Dropdown
£10-15 GBP / tunti
I have a Google Sheet with a lookup table that includes product groups (repeated a number of times) and multiple products within these groups.
I need a script that will create a dynamic dropdown in another sheet.
The first dropdown will select the group (a normal validation dropdown)
The second dropdown will use the first dropdown as a search key. It will then look at another sheet, find all instances of that search key (product group_, and return (as a dropdown) the relevant products within that group.
I have seen a way of doing this with a script, but only when the product group is given once, not multiple times. An example of the raw data is below:
Product Group Product
Group 1 Product A
Group 1 Product B
Group 2 Product C
Group 2 Product D
Group 2 Product E
The orginal Google Sheet will be shared with the selected bidder.
This should be a fairly short exercise for someone who knows what they are doing
Projektin tunnus: #17875551
Tietoa projektista
Myönnetty käyttäjälle:
I have quite a bit of experience in automating Google sheets and It should be fairly simple task. I would be pleased to work on this.
7 freelanceria on tarjonnut keskimäärin £12/tunti tähän työhön
Hi I am "VBA Developer". Expertised in Web Scraping & VBA Macros.. i can do any excel automation tasks, bulk email handling using outlook,File Conversion i can "SCRAPE" any website either static or dynamic also.. Lisää
Hi, As far as your description goes, you need an application where you will upload the spreadsheet and from that a dropdown will be created of groups. based on the group selection products will be sorted etc. Basically Lisää
