How to generate list of items with same status over three or moresuccessive days

A

AA Arens

I would like to ask the community to help me with the following case.

We do have a vehicle tracking business and need to monitor vehicle
status every day.

We are looking for a way to get a list on a daily basis of vehicles
that has their status not changed over three days.

Columns of the feeder:
Date VehicleNr Status (consider A, B, ..., F)

The idea is to add the feeder on a new sheet, so comparison will be
over more sheets.

Columns of generated list of vehicles with same status over more then
three days:
VehicleNr Status

List generation on the same sheet that is refreshed daily.

The list generation will be done on a daily bases after added the
latest status from that day.

Wat it may make it complicated is that the list may be changed,
vehicles are added or deleted, so I think the script should be
generic.

Bart, Excel 2003.
 
D

Don Guillett

I would like to ask the community to help me with the following case.

We do have a vehicle tracking business and need to monitor vehicle
status every day.

We are looking for a way to get a list on a daily basis of vehicles
that has their status not changed over three days.

Columns of the feeder:
Date VehicleNr Status (consider A, B, ..., F)

The idea is to add the feeder on a new sheet, so comparison will be
over more sheets.

Columns of generated list of vehicles with same status over more then
three days:
VehicleNr Status

List generation on the same sheet that is refreshed daily.

The list generation will be done on a daily bases after added the
latest status from that day.

Wat it may make it complicated is that the list may be changed,
vehicles are added or deleted, so I think the script should be
generic.

Bart, Excel 2003.

Hard to say without seeing. Send your file WITH a compete explanation
and examples to dguillett1 @gmail.com
 
D

dave y.

I would like to ask the community to help me with the following case.

We do have a vehicle tracking business and need to monitor vehicle
status every day.

We are looking for a way to get a list on a daily basis of vehicles
that has their status not changed over three days.

Columns of the feeder:
Date VehicleNr Status (consider A, B, ..., F)

The idea is to add the feeder on a new sheet, so comparison will be
over more sheets.

Columns of generated list of vehicles with same status over more then
three days:
VehicleNr Status

List generation on the same sheet that is refreshed daily.

The list generation will be done on a daily bases after added the
latest status from that day.

Wat it may make it complicated is that the list may be changed,
vehicles are added or deleted, so I think the script should be
generic.

Bart, Excel 2003.


At some point it's not really a technical question, you just
have to sit down, lay it out and do the work!

:))

dave y.
 
A

AA Arens

At some point it's not really a technical question, you just
have to sit down, lay it out and do the work!

  :))

dave y.

Hi Don, your email seems to be invalid.
 

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

Top