Copy worksheet with current date as part of variable name

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Copy worksheet with current date as part of variable name

FAQ

Thread Tools

Display Modes

04-19-2018, 09:25 PM

kevinbradley57 kevinbradley57 is offline

Windows 7 64bit Copy worksheet with current date as part of variable name

Office 2010 64bit

Advanced Beginner

Join Date: Jul 2017

Posts: 89

kevinbradley57 is on a distinguished road

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Setting a Worksheet Name as a Variable Help	rod147	Excel Programming	3	11-25-2016 08:50 AM
Date picker content control to always show current date.	lucky16	Word VBA	2	07-01-2016 01:14 PM
Variable to rename a tab in a worksheet via VBA	Chayes	Excel Programming	5	08-07-2012 02:03 AM
Meaning of current date vs status date when saving baselines	ketanco	Project	1	02-08-2012 02:20 PM
How to call current PC date and/or current PC year	KIM SOLIS	Excel	2	11-04-2011 06:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:29 AM.