I searching for a method as well as a specific way to get information from a
table of data. Here is a small subset of the data:
# ID Tag Mach F Cause Fail Type Site ID Site Name Sort Plan Run
Start Date Time Event Date Time Delta Hours Event Day
53 J18CUSA048N080100000037T 72 1 LOC 802000000 Denver
P&DC 143F7802 7/31/2007 18:02 7/31/2007 18:05 0 Tue
53 J18CUSA048N080100000037T 121 1 LOC 601000000 Carol Stream
P&DC 463F7GLA 8/2/2007 16:16 8/2/2007 17:31 47 Thu
53 J18CUSA048N080100000037T 2346 3 LOC 802000000 Denver
P&DC 146F7020 8/5/2007 23:50 8/5/2007 23:55 78 Sun
53 J18CUSA048N080100000037T 2068 2 LOC 802000000 Denver
P&DC 144F7800 8/6/2007 3:08 8/6/2007 4:08 4 Mon
54 J18CUSA048N080101200230T 95 2 LOC 802000000 Denver
P&DC 141F7802 7/31/2007 23:10 7/31/2007 23:21 0 Tue
54 J18CUSA048N080101200230T 162 2 LOC 802000000 Denver
P&DC 143F7802 8/4/2007 21:46 8/4/2007 21:50 94 Sat
54 J18CUSA048N080101200230T 2068 1 LOC 802000000 Denver
P&DC 144F7800 8/8/2007 2:58 8/8/2007 6:17 80 Wed

What I would like to be able to do is select a group of the data based on
the ID Tag. Then working within this group to pull certain pieces of
information. For example I would want to get the first and last Event Date
Time for each ID Tag, the First and Last Site name along with the name of the
site where the piece was at the wrong site (Carol Stream P&DC).
Eventually I would like to be able to select whatever I need from this data.
Right now I am using VBA and walking through the table and using IF Then
getting the bit of data I need whenever the ID Tag changes. This is starting
to get cumbersome as I try to get different bits of data from the table.
Then I'm writing the result to another worksheet as a summary.
I realize a database would probably be the way to go, but we only have Excel
to use consistently across the company. So I need to find a way to do this
in Excel.
More than anything I'm hoping someone has a better method to do this.

Thanks
Mike

Mike, this looks like the kind of thing I have experience with.
Unfortunately, because of the newsgroup word wrap the info looks like
gibberish. And the problem is rather complex. Could take some time to work
through. If you want to explore further, post back and we'll work out
something.
James
"mikebres" wrote in message
...
I searching for a method as well as a specific way to get information from
a
table of data. Here is a small subset of the data:
# ID Tag Mach F Cause Fail Type Site ID Site Name Sort Plan Run
Start Date Time Event Date Time Delta Hours Event Day
53 J18CUSA048N080100000037T 72 1 LOC 802000000 Denver
P&DC 143F7802 7/31/2007 18:02 7/31/2007 18:05 0 Tue
53 J18CUSA048N080100000037T 121 1 LOC 601000000 Carol Stream
P&DC 463F7GLA 8/2/2007 16:16 8/2/2007 17:31 47 Thu
53 J18CUSA048N080100000037T 2346 3 LOC 802000000 Denver
P&DC 146F7020 8/5/2007 23:50 8/5/2007 23:55 78 Sun
53 J18CUSA048N080100000037T 2068 2 LOC 802000000 Denver
P&DC 144F7800 8/6/2007 3:08 8/6/2007 4:08 4 Mon
54 J18CUSA048N080101200230T 95 2 LOC 802000000 Denver
P&DC 141F7802 7/31/2007 23:10 7/31/2007 23:21 0 Tue
54 J18CUSA048N080101200230T 162 2 LOC 802000000 Denver
P&DC 143F7802 8/4/2007 21:46 8/4/2007 21:50 94 Sat
54 J18CUSA048N080101200230T 2068 1 LOC 802000000 Denver
P&DC 144F7800 8/8/2007 2:58 8/8/2007 6:17 80 Wed

What I would like to be able to do is select a group of the data based on
the ID Tag. Then working within this group to pull certain pieces of
information. For example I would want to get the first and last Event
Date
Time for each ID Tag, the First and Last Site name along with the name of
the
site where the piece was at the wrong site (Carol Stream P&DC).
Eventually I would like to be able to select whatever I need from this
data.
Right now I am using VBA and walking through the table and using IF Then
getting the bit of data I need whenever the ID Tag changes. This is
starting
to get cumbersome as I try to get different bits of data from the table.
Then I'm writing the result to another worksheet as a summary.
I realize a database would probably be the way to go, but we only have
Excel
to use consistently across the company. So I need to find a way to do
this
in Excel.
More than anything I'm hoping someone has a better method to do this.

Thanks
Mike

Zone, thank you. Yes I would like to explore this further. What do you
recomend?

"Zone" wrote:

Mike, this looks like the kind of thing I have experience with.
Unfortunately, because of the newsgroup word wrap the info looks like
gibberish. And the problem is rather complex. Could take some time to work
through. If you want to explore further, post back and we'll work out
something.
James
"mikebres" wrote in message
...
I searching for a method as well as a specific way to get information from
a
table of data. Here is a small subset of the data:
# ID Tag Mach F Cause Fail Type Site ID Site Name Sort Plan Run
Start Date Time Event Date Time Delta Hours Event Day
53 J18CUSA048N080100000037T 72 1 LOC 802000000 Denver
P&DC 143F7802 7/31/2007 18:02 7/31/2007 18:05 0 Tue
53 J18CUSA048N080100000037T 121 1 LOC 601000000 Carol Stream
P&DC 463F7GLA 8/2/2007 16:16 8/2/2007 17:31 47 Thu
53 J18CUSA048N080100000037T 2346 3 LOC 802000000 Denver
P&DC 146F7020 8/5/2007 23:50 8/5/2007 23:55 78 Sun
53 J18CUSA048N080100000037T 2068 2 LOC 802000000 Denver
P&DC 144F7800 8/6/2007 3:08 8/6/2007 4:08 4 Mon
54 J18CUSA048N080101200230T 95 2 LOC 802000000 Denver
P&DC 141F7802 7/31/2007 23:10 7/31/2007 23:21 0 Tue
54 J18CUSA048N080101200230T 162 2 LOC 802000000 Denver
P&DC 143F7802 8/4/2007 21:46 8/4/2007 21:50 94 Sat
54 J18CUSA048N080101200230T 2068 1 LOC 802000000 Denver
P&DC 144F7800 8/8/2007 2:58 8/8/2007 6:17 80 Wed

What I would like to be able to do is select a group of the data based on
the ID Tag. Then working within this group to pull certain pieces of
information. For example I would want to get the first and last Event
Date
Time for each ID Tag, the First and Last Site name along with the name of
the
site where the piece was at the wrong site (Carol Stream P&DC).
Eventually I would like to be able to select whatever I need from this
data.
Right now I am using VBA and walking through the table and using IF Then
getting the bit of data I need whenever the ID Tag changes. This is
starting
to get cumbersome as I try to get different bits of data from the table.
Then I'm writing the result to another worksheet as a summary.
I realize a database would probably be the way to go, but we only have
Excel
to use consistently across the company. So I need to find a way to do
this
in Excel.
More than anything I'm hoping someone has a better method to do this.

Thanks
Mike

Mike, you can go ahead and e-mail me
, removing the nospam from the address. We'll
discuss.
James
"mikebres" wrote in message
...
Zone, thank you. Yes I would like to explore this further. What do you
recomend?

"Zone" wrote:

Mike, this looks like the kind of thing I have experience with.
Unfortunately, because of the newsgroup word wrap the info looks like
gibberish. And the problem is rather complex. Could take some time to
work
through. If you want to explore further, post back and we'll work out
something.
James
"mikebres" wrote in message
...
I searching for a method as well as a specific way to get information
from
a
table of data. Here is a small subset of the data:
# ID Tag Mach F Cause Fail Type Site ID Site Name Sort Plan Run
Start Date Time Event Date Time Delta Hours Event Day
53 J18CUSA048N080100000037T 72 1 LOC 802000000 Denver
P&DC 143F7802 7/31/2007 18:02 7/31/2007 18:05 0 Tue
53 J18CUSA048N080100000037T 121 1 LOC 601000000 Carol Stream
P&DC 463F7GLA 8/2/2007 16:16 8/2/2007 17:31 47 Thu
53 J18CUSA048N080100000037T 2346 3 LOC 802000000 Denver
P&DC 146F7020 8/5/2007 23:50 8/5/2007 23:55 78 Sun
53 J18CUSA048N080100000037T 2068 2 LOC 802000000 Denver
P&DC 144F7800 8/6/2007 3:08 8/6/2007 4:08 4 Mon
54 J18CUSA048N080101200230T 95 2 LOC 802000000 Denver
P&DC 141F7802 7/31/2007 23:10 7/31/2007 23:21 0 Tue
54 J18CUSA048N080101200230T 162 2 LOC 802000000 Denver
P&DC 143F7802 8/4/2007 21:46 8/4/2007 21:50 94 Sat
54 J18CUSA048N080101200230T 2068 1 LOC 802000000 Denver
P&DC 144F7800 8/8/2007 2:58 8/8/2007 6:17 80 Wed

What I would like to be able to do is select a group of the data based
on
the ID Tag. Then working within this group to pull certain pieces of
information. For example I would want to get the first and last Event
Date
Time for each ID Tag, the First and Last Site name along with the name
of
the
site where the piece was at the wrong site (Carol Stream P&DC).
Eventually I would like to be able to select whatever I need from this
data.
Right now I am using VBA and walking through the table and using IF
Then
getting the bit of data I need whenever the ID Tag changes. This is
starting
to get cumbersome as I try to get different bits of data from the
table.
Then I'm writing the result to another worksheet as a summary.
I realize a database would probably be the way to go, but we only have
Excel
to use consistently across the company. So I need to find a way to do
this
in Excel.
More than anything I'm hoping someone has a better method to do this.

Thanks
Mike