Thread: [Solved] Copy worksheet with current date as part of variable name
View Single Post
 
Old 04-19-2018, 09:25 PM
kevinbradley57 kevinbradley57 is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
  
Join Date: Jul 2017
Posts: 89
kevinbradley57 is on a distinguished road
Default 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
Reply With Quote