I am having Date in Col A and Employee Nos in Col B.


01-03-2014 123
01-03-2014 234
01-03-2014 345
02-03-2014 123
02-03-2014 234
02-03-2014 345

What I want is to fill the Col A with the Dates for the entire month along with the same employee nos in Col B using fill handle.

01-03-2014 111
01-03-2014 222
01-03-2014 333
02-03-2014 111
02-03-2014 222
02-03-2014 333
03-03-2014 111
03-03-2014 222
03-03-2014 333
04-03-2014 111
04-03-2014 222
04-03-2014 333
..
..
..
31-03-2014 111
31-03-2014 222
31-03-2014 333


How can I achieve this.?

-via135