Hi

I have a number of spreadsheets. The design of these spreadsheets are the same, though the data on them is different. Due to a change two of the cells that drive the calculations on the spreadsheets need to be updated. If I had know before that this was likely to happen I would have linked them to a different spreadsheet but hindsight is a wonderful thing.

So what I need is a script that will take a figure from the spreadsheet I have open, open additional spreadsheets, update two cells and a specific tab, then save and close them. The other option would be a script that would open spreadsheets and amend the cells to point at the additional spreadsheet that contains the correct figure.

Anyone able to point me in the right direction?