R
Richard
OS: MS XP
Excel: 2002
I have a table with six columns, Date, Name, Route, In, Comment and Out. I
need help with a macro to do the following:
1) The 1st date of each week for us starts on a Sunday and goes through the
following Saturday.
2) The table contains work assignments for bus drivers and may contain many
pieces of work in any one day.
3) Some days the drivers are not working.
4) An example of the Table is:
Date Name Route In Comment Out
5/19/08 Smith 210 10:15 Ride 14:15
5/23/08 Smith 215 12:25 Trip 14:45
5/23/08 Smith 217 13:15 Lunch 15:14
5/23/08 Smith 218 16:17 Lewes 18:15
5/24/08 Smith 220 19:34 Testing 20:15
5/20/08 Thomas 210 10:15 Ride 14:15
5/23/08 Thomas 215 12:25 Trip 14:45
5/23/08 Thomas 217 13:15 Lunch 15:14
5/23/08 Thomas 218 16:17 Lewes 18:15
5/26/08 Thomas 220 19:34 Testing 20:15
5/2608 Thomas 227 09:00 Lunch 16:17
5/2608 Thomas 301 12:15 Lewes 17:34
5/2608 Thomas 415 4:35 Testing 20:10
5) I need to insert one record for each day the driver isn’t working.
Either at the bottom of the table in in the proper date sequence.
6) In other words if there is a date missing in the 7 day sequence say from
05/18/08 through 05/26/08 then insert one record for the missing date.
7) At the beginning of each week we can insert the starting date of the
seven day sequence in Cell A1.
8) There are many drivers maybe 55.
Is it possible to do this with a macro???
Thanks in advance.
Excel: 2002
I have a table with six columns, Date, Name, Route, In, Comment and Out. I
need help with a macro to do the following:
1) The 1st date of each week for us starts on a Sunday and goes through the
following Saturday.
2) The table contains work assignments for bus drivers and may contain many
pieces of work in any one day.
3) Some days the drivers are not working.
4) An example of the Table is:
Date Name Route In Comment Out
5/19/08 Smith 210 10:15 Ride 14:15
5/23/08 Smith 215 12:25 Trip 14:45
5/23/08 Smith 217 13:15 Lunch 15:14
5/23/08 Smith 218 16:17 Lewes 18:15
5/24/08 Smith 220 19:34 Testing 20:15
5/20/08 Thomas 210 10:15 Ride 14:15
5/23/08 Thomas 215 12:25 Trip 14:45
5/23/08 Thomas 217 13:15 Lunch 15:14
5/23/08 Thomas 218 16:17 Lewes 18:15
5/26/08 Thomas 220 19:34 Testing 20:15
5/2608 Thomas 227 09:00 Lunch 16:17
5/2608 Thomas 301 12:15 Lewes 17:34
5/2608 Thomas 415 4:35 Testing 20:10
5) I need to insert one record for each day the driver isn’t working.
Either at the bottom of the table in in the proper date sequence.
6) In other words if there is a date missing in the 7 day sequence say from
05/18/08 through 05/26/08 then insert one record for the missing date.
7) At the beginning of each week we can insert the starting date of the
seven day sequence in Cell A1.
8) There are many drivers maybe 55.
Is it possible to do this with a macro???
Thanks in advance.