Hi,
I need to create a macro running from an open Master file.xlsx where it will firstly delete specific tabs, there are 13 of them.
Then it will look at 13 individual closed files saved in the same directory and copy a specific single tab from each of them, pastes them into the Master file and rename each tab to something else.
I will need to run this macro every month so the source of the files will change every month e.g. for Nov data, it will need to look into the Nov file, for Dec - the Dec file etc.
Would anyone be able to help? Thank you.
I need to create a macro running from an open Master file.xlsx where it will firstly delete specific tabs, there are 13 of them.
Then it will look at 13 individual closed files saved in the same directory and copy a specific single tab from each of them, pastes them into the Master file and rename each tab to something else.
I will need to run this macro every month so the source of the files will change every month e.g. for Nov data, it will need to look into the Nov file, for Dec - the Dec file etc.
Would anyone be able to help? Thank you.