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 |
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 |
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] |
All times are GMT +1. The time now is 08:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com