copying_data_using_FillHandle

[via135]

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

 

[via135]

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

any help please..??!!