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.


NO there is no way of doing that without macros.

However, if your tasks are really exactly the same you can record a macro to repeat them in all workbooks.

  • could you also tell me how to copy macros from one file to another. I don't have a lot of experience with them. – Sarthak Nigam Aug 8 '18 at 15:22
  • You can specify location of the macro when you start recording, I suggest recording it in a new workbook. Then you can run it in any workbook as far as the file containing it is open. My link gives instructions on running the macros too. – Máté Juhász Aug 8 '18 at 16:09

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.