copying_data_using_FillHandle

V

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
 
V

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
Click to expand...

any help please..??!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

time_report_date-wise_employee-wise 6
Subtracting time...again 2
date mismatching 2
Pass date from one form to another form in MS Access 1
SUM Q 2
Reverse Index Match 2
Convert table by date to array 6
Combine two sets of overlapping Date/Time data into 3 columns. 3

Top