copy sheet with updated dates

=?Utf-8?B?dmxhZGkxNg==?=

Guest

Posts: n/a

27th Feb 2006

I have a sheet with a schedule of random events (duties) for employees. At
the top of the sheet I have "For the week of March 6, 2006." I would like
to copy the sheet and have the date automatically move +7 days.

My goal is to print out 6 months or a years worth and not have to go through
and add the date to each sheet.

Any ideas?

Thanks

« List date adjacent to duplicates? | Adding A "Timer" to a Macro »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Updated sheet content is not copy pasting from sheet1 to sheet2	arun	Microsoft Excel Programming	2	25th May 2009 09:04 PM
Why do dates change when I copy/paste into another sheet?	maloden	Microsoft Excel Misc	1	21st May 2008 05:41 PM
copy pasting dates from one sheet to another	=?Utf-8?B?MzYwS2lk?=	Microsoft Excel Misc	3	1st Jun 2006 04:52 AM
when i move or copy a sheet, dates change by one day??	=?Utf-8?B?RGV2bw==?=	Microsoft Excel Misc	2	5th Feb 2006 03:01 PM
Links don't get automatically updated in a sheet copy?	StargateFanFromWork	Microsoft Excel Programming	0	7th Dec 2005 07:03 PM