Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto- Fill Dates?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto- Fill Dates?
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto- Fill Dates?
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] |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto fill dates | Excel Worksheet Functions | |||
Auto fill dates | Excel Worksheet Functions | |||
auto fill row with dates | Excel Discussion (Misc queries) | |||
How to Auto fill dates on a schedule | Excel Discussion (Misc queries) | |||
How do I auto-fill consecutive dates ? | Excel Worksheet Functions |