How to apply same calculations to many different spreadsheets?

asked 2017-05-14 19:49:08 +0200

galaxian gravatar image

I have a large number of different spreadsheets where the data is in the same position and same format etc. I have some quite complicated calculations I want to apply to all of them.

Is there any better way of doing this than copying the same block of calculations on to every different spreadsheet?

Is there for example any way of getting the spreadsheet with the formulas on it to apply itself to many different spreadsheets?

A bonus would be having the results reported back to yet another spreadsheet that summaries all the results.

Thanks.

edit retag flag offensive close merge delete