Hi,

I have a spreadsheet as per the enclosed attachment. The top date is
always Today's date, regardless of when the spreadsheet is opened. The
rest of the dates are Today's date plus 1, plus 2, plus3, etc.
Therefore, the dates are moving up the table, day by day. The Saturdays
are linked to the correct dates by using the
=IF(WEEKDAY(F6)=7,"Saturday", "") function, so they are moving up the
screen as well.

The horizantal lines between the weeks move correctly due to
Conditional Formatting (thanks to bpeltzer for that tip).

I would like to merge the blocks of cells that make up a week in such a
way that the merged group of cells moves up the table correctly with
their corrosponding dates.

I have manually merged the top row of cells in the attachment to
indicate what I intend to do, but tomorrow, when the dates have moved
up one, it will look all wrong again.

Is what I want to do possible, and if so, how is it done?

many thanks

Spike


+-------------------------------------------------------------------+
|Filename: dates.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4064 |
+-------------------------------------------------------------------+

--
SpikeUK
------------------------------------------------------------------------
SpikeUK's Profile: http://www.excelforum.com/member.php...o&userid=28997
View this thread: http://www.excelforum.com/showthread...hreadid=487999