search or find, and extract?

[SusanInTexas]

Hello,
I need help using Excel 2007.

I have 10 trucks driving for me. Each truck will be driving for several of
our customers. In one workbook, I have a seperate worksheet for each truck.
That look something like this:

Truck #1
Date Weight(tons) Miles Cost Customer
5/12 12 17 2.54 WWR
5/13 6.5 17 1.23 WWR
5/17 8.5 6 3.30 KGB
so on....

I also need a worksheet for each customer (for billing). The customers need
to see the dates, weights, and miles of the loads hauled for them (more than
one truck will be hauling for them).

So I would like to have a customer worksheet that looks something like this:

Customer: WWR
Date Weight(tons) Miles Cost
5/12 12 17 2.54
5/13 6.5 17 1.23
so on....

Here's my question. I want to do this without entering data twice (once for
the truck and once for the customer) or without a lot of copying/pasteing. I
need to be able to search by the customer column (in the trucks' worksheets).
Find all of the places where that customer's name is listed. Then put the
corresponding rows of data on that customer's worksheet. Any ideas?

Thanks,
Susan in Texas

If this doesn't make sense, will you let me know so I can try to make it
clearer.
Thanks again.

 

[Don Guillett]

Start by looking the the vba help index for FINDNEXT. There is a good
example on finding. Then incorporate copy/paste code instead of the action
in the example.