Hey, I am trying use a Macro to copy a sheet called "Copy" and then rename it with the month January and then copy data from another sheet into it. Now this will happen every month and I need the macro to somehow read that the month January is already there and create the new sheet under the name February and the same for the month of March and so on and so forth.
The whole macro is under the name "Sheet_copy" and it is too long to post here, so I will post up a demo file. This is the first part of the code that I did. Don't laugh, b/c I don't know how to write code so I just used the record macro function.
And on the off chance someone is willing to streamline the code for everything else that I am having it do it would be very much appreciated.
Bookmarks