PDA

View Full Version : Solved: Use Advanced Filter In Excel 2003



mattster1010
01-06-2011, 07:13 AM
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
01-06-2011, 12:32 PM
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
01-07-2011, 08:39 AM
Many thanks Stan. Solved.