Excel 2007 : Find date, fill date sequentially, find next date

I'm seeking help with a call detail sheet that needs to have all the dates filled in.
I need to find the date in column A, once that date is found copy it sequentially down until the next date is found, then copy that date down sequentially and so on.
If it can be a macro button or copy the output to another tab within the workbook that would be cool.

I researched the forums and could not find a solution.
I wrote a procedure in module1 but it trashed the worksheet, which I since deleted.

Any help would be appreciated, I trying to help a friend out and spent a lot of time with no luck..

See attached example.

Thanks in advance..
T
Call_Detail_Test.xlsm

Dear ,

follow following steps :
1)select the call_date column from "Originating # 123 456-1000 123-456-1999" till "total:
2) press F5 button -->special -->blanks
3) Now your cell pointer will be in A12 Cell .just press equal to (=) sign and press up arrow button .Now cell pointer will be in the A11 cell highlighting the date 2009/11/11.
4) now press control+enter key simultaneously .
5) you will get the desired result

if any help needed pls reply back

Originally Posted by abhijit786

Dear ,

follow following steps :
1)select the call_date column from "Originating # 123 456-1000 123-456-1999" till "total:
2) press F5 button -->special -->blanks
3) Now your cell pointer will be in A12 Cell .just press equal to (=) sign and press up arrow button .Now cell pointer will be in the A11 cell highlighting the date 2009/11/11.
4) now press control+enter key simultaneously .
5) you will get the desired result

if any help needed pls reply back

abhijit786:
That worked sweet from a manual basis..

They only problem is that the data could be up to 65535 cells long and I need that to be automated from a macro button.
Even it it would parse the date, insert the dates sequentially then output to a new tab.
Is it even possible to have it parse that column and fill it in?