Macro or an excel formula to filter data

**vijanand1279** · 01-19-2012, 04:13 AM

Hi,

I am looking for a macro of an excel formula to filter the data for the Cost center selected in A2, the data should list down in A5 for that cost center details with all the account codes with subtotal on each account code.. Please help!

Attaching the file for your reference with the filter sheet and summary sheet.

Regards,
Vijay

**teylyn** · 01-19-2012, 04:52 AM

Hello,

you can use Advanced filter for this. In Excel 2003 follow these steps:

- Click Data > Filter > Advanced Filter
- in the dialogue that opens, do the following:
-- select "Copy to another location"
-- for "List range" click the cell selection button, then click the Summary sheet and select A1 to C2037
-- for "Criteria range" select $A$1:$A$2 on the "Filter Sheet"
-- for "Copy to" select $A$4:$C$4 on the "Filter Sheet"
-- Hit OK

The filtered list will now be in your filter sheet.

cheers,