Jun 02 2021 09:47 AM
Hello,
I am using Excel's Macro recorder and I've done this probably about a dozen times, re-recording the same macro where I have a file that is exported, and then basically filtered and shuffled to create two files: one for online data, the other for on-site data.
When I run the macro, it always stops midway through and says 'outside of script' - so how do I create a macro where I can create two excel files and save them as different file names?