Copy worksheet with current date as part of variable name
I have an Excel source worksheet generated daily with filename SearchResultsDailymm.dd.yy where mm.dd.yy is the current date. I need code that will copy Columns A2:J of the source worksheet into Columns A2:J of a template worksheet with filename Daily Plan Status mm.dd.yy. The code would be housed in the target file.
Thank you.
Last edited by kevinbradley57; 04-19-2018 at 09:25 PM.
Reason: Fixed typo
|