I was wondering what I would have to do to be able to make a macro tha
would take the a list of sundays (lets say ten) bring the most recen
five to the top of the list then auto fill the next five sundays(wit
their dates) in the five cells that are now open under them.



--
Message posted from http://www.ExcelForum.com

I figured this one out on my own. I had to create a macro that would d
all the work for me. quite a pain in the butt but it works.
:cool

--
Message posted from http://www.ExcelForum.com

Grüezi DangerMouse114

DangerMouse114 schrieb am 07.06.2004

I was wondering what I would have to do to be able to make a macro that
would take the a list of sundays (lets say ten) bring the most recent
five to the top of the list then auto fill the next five sundays(with
their dates) in the five cells that are now open under them.

In A1 copy the following formula (with VBA, if you like)

=TODAY()-35-WEEKDAY(TODAY(),2)

In A2 copy the following and autofill as far as you like with the
autofillhandle in the bottom right corner of the cell;

=A1+7

--
Regards

Thomas Ramel
- MVP for Microsoft-Excel -

[Win XP Pro SP-1 / xl2000 SP-3]