Centralizing data in another worksheet

[D2C]

Hi there,

I have a table with all suppliers and their orders.
Now I inserted a second worksheet and would like to centralize the amounts of the orders and the suppliers:

Worksheet 1

Column A Column B
Supplier1 100
Supplier 2 50
Supplier 3 75
Supplier 1 200

So in my second worksheet I would like to have the list of the suppliers without double items:

Worksheet 2

Supplier 1 200
Supplier 2 50
Supplier 3 75

The function for the amount is no problem, I already found that. How can I search the names of the suppliers and filter them?

Hope that you can help,

greetz,

d2c

 

[hopelessliar]

You can find the info too do this here:

http://www.cpearson.com/excel/duplicat.htm

Good Luck

 

[xlbo]

Pretty sure you can just whhack a pivot table over your data and it will do exactly what you have requested

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question