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

Hard to say without seeing. Send your file WITH a compete explanation
and examples to dguillett1 @gmail.com
 
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.
Click to expand...

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

Similar Threads

VLOOKUP with a date, from A1 = Now() 3
How to list cells from two sheets that has different values in theirneighboring column? 8
How to set this up? 9
Can I keep this in XL (vice Access)? 2
Go to sheet based on ListBox selection 5
How create & use list of date-based tasks to use on each new case? 4
How to generate list of values from 2nd column that are not in 1st column? 12
form validation determines which sheet to add data 1

Top