Hi all,
I'm writing a macro that I want to copy two different worksheets for each day of the month and name them accordingly. For example, for April 1st, I have one worksheet named 4-1 and the second one named 4-1b. I would like to write a macro that copies these two sheets for each day of the month and name them according to that day. Any help would be appreciated. I am familiar with vb and vba and input boxes. I really just need the loop that with copy and name the worksheets.
Thanks everyone!
I'm writing a macro that I want to copy two different worksheets for each day of the month and name them accordingly. For example, for April 1st, I have one worksheet named 4-1 and the second one named 4-1b. I would like to write a macro that copies these two sheets for each day of the month and name them according to that day. Any help would be appreciated. I am familiar with vb and vba and input boxes. I really just need the loop that with copy and name the worksheets.
Thanks everyone!
