I have a worksheet with 3 colums. The first column has a customer name, the
second their order and the third the driver's name.

I would like to create a summary sheet that would look up a particular
driver's name and list out all the customers and orders for that driver. I
would like them listed with out any blank row.

thx
Ron

Try this............

Click on a cell within your data, then do Data Filter
AutoFilter............
Then Left-click on the little arrow at the top of the column with the
drivers names, and select the driver you wish.........all non-relavent data
will "disappear" ............leaving you only the rows pertaining to your
selected driver.............

To return to normal, do Data Filter AutoFilter again, (it's a toggle)

Vaya con Dios,
Chuck, CABGx3


"Ron" wrote in message
...
I have a worksheet with 3 colums. The first column has a customer name,
the
second their order and the third the driver's name.

I would like to create a summary sheet that would look up a particular
driver's name and list out all the customers and orders for that driver.
I
would like them listed with out any blank row.

thx
Ron

Thanks CLR,

That is what I am doing now, and then I cut and paste each driver in a
seperate sheet. I am trying to link the drivers sheet with the master order
sheet where it automatically selects those orders for that particular driver
and list it all out with no blank rows. Is this possible?

"CLR" wrote:

Try this............

Click on a cell within your data, then do Data Filter
AutoFilter............
Then Left-click on the little arrow at the top of the column with the
drivers names, and select the driver you wish.........all non-relavent data
will "disappear" ............leaving you only the rows pertaining to your
selected driver.............

To return to normal, do Data Filter AutoFilter again, (it's a toggle)

Vaya con Dios,
Chuck, CABGx3


"Ron" wrote in message
...
I have a worksheet with 3 colums. The first column has a customer name,
the
second their order and the third the driver's name.

I would like to create a summary sheet that would look up a particular
driver's name and list out all the customers and orders for that driver.
I
would like them listed with out any blank row.

thx
Ron

Think this set up will deliver what you're looking for ..

Assume the sample source table is in Sheet1,
cols A to C, data from row2 down

CustN Order DriverN
Cust1 Ord1 Drv1
Cust2 Ord2 Drv2
Cust3 Ord3 Drv1
Cust4 Ord4 Drv3
Cust5 Ord5 Drv2
Cust6 Ord6 Drv2
etc

Use an empty col to the right, say col E?

Put in E1: =Sheet2!A1

Put in E2: =IF(C2="","",IF(C2=$E$1,ROW(),""))

Copy E2 down to say E100,
to cover the max expected data in the table

In Sheet2 (this will be your summary sheet)
------------

Cell A1 will be earmarked for input of the driver
(Input in A1, say: Drv2)

Paste the headers into A2:B2: CustN, Order

Put in A3:

=IF(ISERROR(SMALL(Sheet1!$E:$E,ROWS($A$1:A1))),"", INDEX(Sheet1!A:A,MATCH(SMA
LL(Sheet1!$E:$E,ROWS($A$1:A1)),Sheet1!$E:$E,0)))

Copy A3 across to B3, fill down to B101
(cover the same range as in Sheet1)

In A3:B3 down will be returned the desired results
for the input in A1, i.e. you'll get:

Drv2
CustN Order
----------------
Cust2 Ord2
Cust5 Ord5
Cust6 Ord6
( rest are blank rows )

Change the input in A1 to: Drv1

Drv1
CustN Order
---------------
Cust1 Ord1
Cust3 Ord3
( rest are blank rows )

And so on ..

You could also create a data validation list in A1 for easy selection of the
driver

Select A1
Click Data Validation
Under Allow: select "List"
Enter in Source: Drv1, Drv2, Drv3
Click OK

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

"Ron" wrote
... trying to link the drivers sheet with the master order
sheet where it automatically selects those orders
for that particular driver
and list it all out with no blank rows.

Think this set up will deliver what you're looking for ..

Assume the sample source table is in Sheet1,
cols A to C, data from row2 down

CustN Order DriverN
Cust1 Ord1 Drv1
Cust2 Ord2 Drv2
Cust3 Ord3 Drv1
Cust4 Ord4 Drv3
Cust5 Ord5 Drv2
Cust6 Ord6 Drv2
etc

Use an empty col to the right, say col E?

Put in E1: =Sheet2!A1

Put in E2: =IF(C2="","",IF(C2=$E$1,ROW(),""))

Copy E2 down to say E100,
to cover the max expected data in the table

In Sheet2 (this will be your summary sheet)
------------

Cell A1 will be earmarked for input of the driver
(Input in A1, say: Drv2)

Paste the headers into A2:B2: CustN, Order

Put in A3:

=IF(ISERROR(SMALL(Sheet1!$E:$E,ROWS($A$1:A1))),"", INDEX(Sheet1!A:A,MATCH(SMA
LL(Sheet1!$E:$E,ROWS($A$1:A1)),Sheet1!$E:$E,0)))

Copy A3 across to B3, fill down to B101
(cover the same range as in Sheet1)

In A3:B3 down will be returned the desired results
for the input in A1, i.e. you'll get:

Drv2
CustN Order
----------------
Cust2 Ord2
Cust5 Ord5
Cust6 Ord6
( rest are blank rows )

Change the input in A1 to: Drv1

Drv1
CustN Order
---------------
Cust1 Ord1
Cust3 Ord3
( rest are blank rows )

And so on ..

You could also create a data validation list in A1 for easy selection of the
driver

Select A1
Click Data Validation
Under Allow: select "List"
Enter in Source: Drv1, Drv2, Drv3
Click OK

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

Sorry Ron, I guess I don't get it...........it looks to me like the
AutoFilter procedure will give you a Summary Listing of all of a Drivers
Orders without any blank rows, which I thought was what you wanted.........I
don't understand what you're trying to do from there........the Autofilter
procedure can be automated with macros to run through the list of drivers
and give you a separate printout of each driver individually, if you
wish........

Vaya con Dios,
Chuck, CABGx3



"Ron" wrote in message
...
Thanks CLR,

That is what I am doing now, and then I cut and paste each driver in a
seperate sheet. I am trying to link the drivers sheet with the master
order
sheet where it automatically selects those orders for that particular
driver
and list it all out with no blank rows. Is this possible?

"CLR" wrote:

Try this............

Click on a cell within your data, then do Data Filter
AutoFilter............
Then Left-click on the little arrow at the top of the column with the
drivers names, and select the driver you wish.........all non-relavent
data
will "disappear" ............leaving you only the rows pertaining to
your
selected driver.............

To return to normal, do Data Filter AutoFilter again, (it's a
toggle)

Vaya con Dios,
Chuck, CABGx3


"Ron" wrote in message
...
I have a worksheet with 3 colums. The first column has a customer
name,
the
second their order and the third the driver's name.

I would like to create a summary sheet that would look up a particular
driver's name and list out all the customers and orders for that
driver.
I
would like them listed with out any blank row.

thx
Ron

Put in E1: =Sheet2!A1
A slight tweak to the formula in Sheet1's E1
Put instead in E1: =IF(Sheet2!A1="","",Sheet2!A1)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

Hi Max,

This is Pong, I got the info. from Ron. We try to apply it into our
worksheet. The first part (sheet 1) is OK. Outcome as what we expect. But
when come to the summary sheet, nothing show. We try a lot of TR but still
failed. Wonder is it ok if I can send you my file and you can help us out.

Hope to hear a good news from you.

Thanks
Pong

"Max" wrote:

Put in E1: =Sheet2!A1
A slight tweak to the formula in Sheet1's E1
Put instead in E1: =IF(Sheet2!A1="","",Sheet2!A1)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

Ok, email to either:
demechanik <atyahoo<dotcom, or
xdemechanik <atyahoo<dotcom

We try a lot of TR ..
btw, what is TR? <g
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Pong" wrote in message
...
Hi Max,

This is Pong, I got the info. from Ron. We try to apply it into our
worksheet. The first part (sheet 1) is OK. Outcome as what we expect.
But
when come to the summary sheet, nothing show. We try a lot of TR but
still
failed. Wonder is it ok if I can send you my file and you can help us
out.

Hope to hear a good news from you.

Thanks
Pong

Haven't received anything yet.
Not sure whether you've sent the file over ...
(or have you suddenly changed your rmind? <g)
Either way, drop me a reply here, pl
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

Thank you for your support. We did not change our mind. Still need you
advice. will send you the file at the address show above.

"Max" wrote:

Haven't received anything yet.
Not sure whether you've sent the file over ...
(or have you suddenly changed your rmind? <g)
Either way, drop me a reply here, pl
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

What I implemented in your file follows closely along the lines of another
recent post to Scott: http://tinyurl.com/auxdb

File has been sent (zipped) to you.

In Sheet: KeyOrder
----------------------
The 4 drivers' names are listed in BZ1:CC1
(no more formulas in BZ1:CC1)

Put in BZ3: =IF(ISNA($BW3),"",IF($BW3=BZ$1,ROW(),""))
Copy across to CC3, fill down to say CC199
(copy as far down as data is expected in col BW

I also copied pasted some sample data into A3:A50

In Sheet: Don
----------------
Put in A1: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
This will pull-in the sheetname into A1, but file must be saved first

Put in A3:
=IF(ISERROR(SMALL(OFFSET(KeyOrder!$BY:$BY,0,MATCH( $A$1,KeyOrder!$BZ$1:$CC$1,
0)),ROWS($A$1:A1))),"",INDEX(KeyOrder!A:A,MATCH(SM ALL(OFFSET(KeyOrder!$BY:$B
Y,0,MATCH($A$1,KeyOrder!$BZ$1:$CC$1,0)),ROWS($A$1: A1)),OFFSET(KeyOrder!$BY:$
BY,0,MATCH($A$1,KeyOrder!$BZ$1:$CC$1,0)),0)))
Copy A3 across to BY3, fill down to say, BY100

Then just duplicate sheet: Don, and rename with the other 3 drivers' names.

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Pong" wrote in message
...
Thank you for your support. We did not change our mind. Still need you
advice. will send you the file at the address show above.

For those interested, implemented sample file is at:

http://flypicture.com/p.cfm?id=40306
(right-click on link "Download File" at the top)
File: 2_Pong Delivery Template v(1).4.zip
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----