Hello. Newbie here. I would like to create a macro that will create a copy of the active sheet ("25 May 2015") and rename it ("1 June 15") from a list on a separate sheet ("List"). Everytime I use the macro I would like the latest sheet to be copied and renamed to the next name on the list one at a time.
Is this possible? I've found ones that copy into multiple sheets from a list all at once but can't find how to do it one by one and creating a copy of the latest sheet (or active sheet if ran from the latest sheet).
Hope that makes sense.
Thanks
Is this possible? I've found ones that copy into multiple sheets from a list all at once but can't find how to do it one by one and creating a copy of the latest sheet (or active sheet if ran from the latest sheet).
Hope that makes sense.
Thanks