'Syncing a List between different sheets keeping properties sticked to a row
Maybe the title is not explicit enough, but what do I want to achieve, is:
- I want to have a single place to edit a list (customers) with some metadata, to be used across the entire spreadsheet.
- Some sheets may contain editable data as rows tied to the 1st column with the customer Ids. E.g. prices for services for each Customer for each month.
So, when I add an entry (Customer) to the 1st (master) sheet, it appears in the pricing table and doesn't break the existing entries (the rows remain connected).
So far I've not found any native solution for this. Should I look for extensions fo this, or code it using the app script?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|