Solved: Use Advanced Filter In Excel 2003

[mattster1010]

Afternoon Everyone,

I am creating a report in excel using subtotals to total the cost of each account. This works fine.

I'm then applying an advanced filter on the cost column (K) to show records above 250 (>250). The advance filter returns all individual records that qualify for this criteria. However, is there anyway that the advanced filter can look at the subtotals of each account and filter the records using the overall total?

I have uploaded a sample of my data.

Regards,

Matt

[stanleydgrom]

mattster1010,

Detach/open workbook mattster1010 - VE35611 - VP - SDG12.xls, and run macro CreateReport on the worksheet that contains your SUBTOTAL report.

I utilize columns M, N, and O, for the results you may be looking for.


Have a great day,
Stan

[mattster1010]

Many thanks Stan. Solved.