Sum then filter by condition and arrange alphabetically

Hi,

I want to extract data by doing sum C data based on unique list from B column and then filter by condition met in E1 and arranged alphabetically ultimately.

I have done by Pivot but I expect vba so that in a single click it can get the job done rather than following series of steps in pivot.

I have enclosed the file.

It did not worked.In B column there are duplicates which should have been unique.

The output should be in a separate sheet.Also the last row which is simply the total of a "C" column should be ignored

I have attached again the file with sample output what it should have been.

I think the output seems to be wrong.Have you match the sample output in "Output" sheet.Also the formula is displaying should not exist.

Try

Please Login or Register  to view this content.

Thanx for the kind response.But this is not I want.I want to extract data by doing sum C data based on unique list from B column and then filter by condition met in E1 and arranged alphabetically ultimately.Kindly read the post #1.

It will help you to comprehand and I know you can do it as most of the problems you have sought out and eased me which I have faced in my day to day work previously.

Ah 2003...
Try the attached, Scari doesn't allow me to post my code.