Hi Fiona,
My suspicion was right, you will have to do this by learning to write using Google Apps Script – which is getting very technical, very quickly. Basically, you’d have to learn some basic javascript.
The response to my question for you was to check out the same links I’ve shared with you, plus there is a forum in Stack Overflow (a community for developers and programmers) dedicated to this where you could get programmers from around the world help you if you want to give it a go.
References:
- Google Apps Script
- Extending Google Sheets
- Quickstart: Macros, Menus, and Custom Functions
- Stack Overflow
Do you want to try this together? I’m not sure if this will be the fastest way for you to get the outcome you want though…
Rob