Hello,
I have almost 25 different worksheets in one excel file. Now in order to format it I have created a macro for each worksheet. If I go to each worksheet and run the macro for that worksheet it works fine.
Now I'm trying to automate this entire process, run all these macros for the respective worksheet. Can someone please guide or provide me a script that will help me to achieve this task
Any help will be appreciated.
Thank you.