I have a series of excel files all numbered sequentially, having data that is of the same format, but taken at different times. I would like to perform the same operations on all the excel files, these operations include shifting columns and writing formulas in new columns and adding new rows. I do not want to repeat the same operation multiple times. Is there a way to do operations on one excel file and copy them all to another? Some answers, like this one suggest using VBA, which I don't know. Is there a way to do the same without coding?
For reference, I am running office 2016 on mac.