LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vladi16
 
Posts: n/a
Default copy sheet with updated dates

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to copy rng of cells where (value is met) to anther sheet Exit Advantage Excel Worksheet Functions 3 November 12th 05 02:59 AM
Edit / Move or copy sheet stopped working in Excel 2003 kris2u Excel Worksheet Functions 0 October 4th 05 08:20 PM
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM
Excel won't copy outside sheet Jack Sons Excel Discussion (Misc queries) 6 May 17th 05 10:05 PM
Copy formula...sheet 2 sheet Mick New Users to Excel 0 January 26th 05 01:58 AM


All times are GMT +1. The time now is 02:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"