Sometimes you have a forest of spreadsheets each with multiple sheets, but you only want to share a selection of those sheets. You could cut and paste, but that’s error prone and difficult to repeat. You could probably record some kind of macro to do something or other, but that’s fragile. You could write a script, but that’s a lot of work.
Another thing you might want to do is to only make certain columns visible to people with the correct credentials, but not go to the trouble of creating different versions of the summary sheet for different groups. For example, you might want to create a list of employees, vacancies, managers, promotion recommendations etc, but only allow the HR department to see the salaries, and the managers see the promotion recommendations.
This post introduces a library that can summarize selected columns from multiple sheets across multiple spreadsheets into 1 spreadsheet, as well as to optionally apply a public/private key data encryption scheme to selected columns, all via a simple JSON definition file.
Sometimes you have a forest of spreadsheets each with multiple sheets, but you only want to share a selection of those sheets. You could cut and paste, but that’s error prone and difficult to repeat. You could probably record some kind of macro to do something or other, but that’s fragile. You could write a script, but that’s a lot of work.
Another thing you might want to do is to only make certain columns visible to people with the correct credentials, but not go to the trouble of creating different versions of the summary sheet for different groups. For example, you might want to create a list of employees, vacancies, managers, promotion recommendations etc, but only allow the HR department to see the salaries, and the managers see the promotion recommendations.
This post introduces a library that can summarize selected columns from multiple sheets across multiple spreadsheets into 1 spreadsheet, as well as to optionally apply a public/private key data encryption scheme to selected columns, all via a simple JSON definition file.
https://ramblings.mcpher.com/apps-script/add-ons/merging-encrypting/