| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying_data_using_FillHandle
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copying_data_using_FillHandle
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..??!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
