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.