Can someone help me with a code to do the following please?
1. Open a file - Actuals_Country.xlsx
2. Find the sheet with the name containing text "FY - COUNTRY"
3. Replace "COUNTRY" in the sheet name with the first value from a list in an external file (File name: List.xlsx, column A)
4. Save as a new file with the same name but replacing "Country" with the same value from the external list
5. Repeat steps 1-4 but replacing values with the next value in the external list
I have multiple macros that I found on Google, but 2 of them require a popup dialogue and the other keeps duplicating sheets. I'm not smart enough to try to pick it apart and put it back together
1. Open a file - Actuals_Country.xlsx
2. Find the sheet with the name containing text "FY - COUNTRY"
3. Replace "COUNTRY" in the sheet name with the first value from a list in an external file (File name: List.xlsx, column A)
4. Save as a new file with the same name but replacing "Country" with the same value from the external list
5. Repeat steps 1-4 but replacing values with the next value in the external list
I have multiple macros that I found on Google, but 2 of them require a popup dialogue and the other keeps duplicating sheets. I'm not smart enough to try to pick it apart and put it back together