Hello,

Could someone please help me with the following?

I am trying to create two separate excel advanced filters:

1st Filter:

My worksheet is named: DPC Expenses. I wish to create an advanced
filter that prompts the user for a date range (eg 01 - 31 Jan 07) and
also prompts the user for a single Cost Element Code (eg 21008, 21019,
21452, 21097 etc...). After the user has entered the required
information, the advanced filter will need to look up column I (the Cost
column) and add up all the costs that are filtered.

The Date Ordered column is column B. The Cost Element Code column is
column K. The Cost column is column I.

I wish the output to be shown on another worksheet named: Query (which
is in the same workbook). On the Query wooksheet, the user should see
the date range and cost element code entered and the total cost.

2nd Filter:

My worksheet is named: DPC Expenses. I wish to create an advanced
filter that prompts the user for a date range (eg 01 - 31 Jan 07) only.
After the user has entered the required information, the advanced filter
will need to look up column I (the Cost column) and add up all the costs
that are filtered.

The Date Ordered column is column B. The Cost column is column I.

I wish the output to be shown on another worksheet named: Query (which
is in the same workbook). On the Query wooksheet, the user should see
the date range and the total cost.

Any help on this would be greatly appreciated.

Kind regards,

Chris.



*** Sent via Developersdex http://www.developersdex.com ***