Can joining the two sheets help

[navb]

I have two sheets
Sheet1 has 3 columns.(Supplier,Factory,Items)
Sheet2 has 4 columns,(Factory,Items,SKU,Revenue)

Now one supplier can supply in different factories

One supplier can supply multiple items in a factory and one item in a factory can be supplied by multiple suppliers

Also one item can have multiple SKU.

I want to sum the revenue at the supplier level. This means I want to sum revenues for unique SKU corresponding to all items supplied in a factory and for each unique supplier

In short I want to find the total revenues of each supplier based on the above constraint.

How can I do this ? And Can I do this without using a macro ?

NB: SKU is Stock Keeping Unit.

 

[mole999]

have you tried pivot tables for this, it should give you all the answers you need without macros

 

[navb]

How do you run pivot tables on two sheets.? i have data in two sheets and I have to do a join on those two sheets.

 

[mole999]

http://office.microsoft.com/en-us/e...s-into-one-pivottable-report-HA010226585.aspx