Maching Condition

J

jophy

I need to Some favour..

I want to write a filter condition in VBA.

Customer Bank a/C Amount ANSWERE SHOULD BE AS
FOLLOWS
ABC AA 100 ABC AA 150
ABC BB 200 ABC BB 200
CBD AA 50 CBD AA 50
ABC AA 50


I have data in three column-COL-1 contain Customer # and COL-2 contain
Bank A/C and CoL-3 contain Bank deposit amount. Now I want to sum up
all the amount depending Emp# with same bank account

Can any one help me out ?
 
B

Bernie Deitrick

jophy,

Select your table, then use Data | Pivot Table... and set up a pivot
table to sum your desired values based on your desired criteria.

See help for more about using Pivot Tables.

HTH,
Bernie
MS Excel MVP
 
Top