Google Scripts Code for Dynamic Dropdown
£10-15 GBP / ώρα
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
Ταυτότητα Εργασίας: #17875551
Σχετικά με την εργασία
Ανατέθηκε στον:
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 freelancers κάνουν προσφορά κατά μέσο όρο £12/ώρα για αυτή τη δουλειά
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.. Περισσότερα
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 Περισσότερα
