4
43fan
Not sure if something can be done macro wise or not. I've tried using
vlookup as well as some things suggested to me on another board, but nothing
seems to work so far. If a macro could go copy all the pertinent info to
another sheet to print the list, it'd be great! Here's what's up:
We have a vehicle schedule here at work(done manually, daily), and
basically, when there's an X in the cell under a particular shift on a
particular day, that vehicle will run. What I want to do is create a list
from that, by shift, by day, for each day, of all the vehicles running. I
thought Hlookup or Vlookup would do it, but it doesn't seem to work the way
I'd want it to.
Here's how the data looks:
Veh# Mon(1) Mon(2) Tues(1) Tues(2)
123 X X 999 X
Chv Trk 1000 1500 2000
345 X X
Dge Car 3000 3500
In the above, Vehicle 123 would run Monday first and second shift, then not
run Tuesday first shift, then run again Tuesday second shift. There are
blank rows between each set of vehicle data and the numbers you see under
the X's are mileages accumulated since last service. Could be as many as
25(or more?) vehicles listed.
I hope this all makes sense. And actually, on the days they don't run, at
times there are maintenance procedures done, so I could probably use the
same thing to list what's coming due on what day/shift for maintenance.
I think once I get this part working, I can modify it to use for the
servicing, etc...
Thanks!!
Shawn
vlookup as well as some things suggested to me on another board, but nothing
seems to work so far. If a macro could go copy all the pertinent info to
another sheet to print the list, it'd be great! Here's what's up:
We have a vehicle schedule here at work(done manually, daily), and
basically, when there's an X in the cell under a particular shift on a
particular day, that vehicle will run. What I want to do is create a list
from that, by shift, by day, for each day, of all the vehicles running. I
thought Hlookup or Vlookup would do it, but it doesn't seem to work the way
I'd want it to.
Here's how the data looks:
Veh# Mon(1) Mon(2) Tues(1) Tues(2)
123 X X 999 X
Chv Trk 1000 1500 2000
345 X X
Dge Car 3000 3500
In the above, Vehicle 123 would run Monday first and second shift, then not
run Tuesday first shift, then run again Tuesday second shift. There are
blank rows between each set of vehicle data and the numbers you see under
the X's are mileages accumulated since last service. Could be as many as
25(or more?) vehicles listed.
I hope this all makes sense. And actually, on the days they don't run, at
times there are maintenance procedures done, so I could probably use the
same thing to list what's coming due on what day/shift for maintenance.
I think once I get this part working, I can modify it to use for the
servicing, etc...
Thanks!!
Shawn