On Tuesday, 11 March 2014 07:37:47 UTC+5:30, via135 wrote:
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..??!!