That works exactly how i want it, there is one slight problem, that it
starts filling from row 50, when the current row it should start from
is 16, and because its starting all the way down there, it is not
filling the date because it isnt in the cell above it. Any way to get
it to start filling from row 16, where it needs to ?

If you dont understand: 'Screenshot and annotation'
(http://www.yakery.com/images/macrohelp3.png)

Thanks for all the help so far!


--
benb7760
------------------------------------------------------------------------
benb7760's Profile: http://www.excelforum.com/member.php...o&userid=24382
View this thread: http://www.excelforum.com/showthread...hreadid=379710