Update code on one google sheet without having to update on other sheets

Question

I apologize if this is a very basic question but would appreciate if anyone could guide me on this. I have created some code for a set of Google Sheets Workbooks, 14 of them to be exact. But I have found that every time a person reports a problem with the code scripts and I can fix it on one the workbook projects I now have to go and fix it on the other 13 workbooks as well. Most of the times it is just a copy and paste from the fixed workbook to the other 13 workbook's script code which doesn't take much time but, as the number of users grows I may end up having to do this possibly even more times. Expected number of users is 105 by end of year. So I was wondering if there is a way I could have centralized code instead of having it on each workbook and having to do this over and over again.

Answer 1

That is indeed possible. Create the code, common to all spreadsheets in a library. Then in the spreadsheets refer to the function(s) inside the library. On YouTube you can find a lot of tutorials that should get you started. Here's an example.