Automatically copy cells from two week day sheets based from today

MMs4MSU

Guest

Posts: n/a

25th Nov 2009

I have a schedule workbook with the days of the week listed as sheets,
Mon->Sun. I want to have another sheet that displays half of today’s schedule
and half of tomorrow’s schedule but it will change day to day depending on
today. I need it to automatically copy the info so I am not constantly
cutting and pasting or making seven new pages.

« filter and sorting | Chart »

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
Code to copy and paste based on today's date	Code Flunkie	Microsoft Excel Programming	1	16th Jul 2009 09:31 AM
Colouring cells based on day of week?	StargateFan	Microsoft Excel Programming	5	9th Mar 2008 03:51 PM
Automatically copy selective sheets from one workbook to another	=?Utf-8?B?QW5u?=	Microsoft Excel Misc	0	1st Mar 2005 07:09 PM
Copy rows from all sheets based on cell value	Steph	Microsoft Excel Programming	2	16th Feb 2005 10:19 PM
Should be able to name Excel sheets based on cells in workbook	=?Utf-8?B?Y2FsbHNpZ24gQmx1ZSBXb2xmIE9uZSBGaXZl?=	Microsoft Excel Misc	1	22nd Jan 2005 03:30 PM