(advanced) Filter -> Sum projects -> Average

[Emperor]

Hi all,
If got a large document in which projects of our company from the start of 2008 are listed with full details (about 25.000 rows). In the document Column A are all the projects, about 130 uniques.

SampleXL file:
http://wtrns.fr/_YdkWZXSrwazHB

What I need is not really hard...I think
But I have no idea how

I've created a Userform for the user:

Now what I need is a way to apply this filter on my data.
So only display which items are still selected after clicking a CMDbutton on the Userform.

After the filtering step 2:
Sum the column "€/m2" per project.

Step3:
Average the projects Sum to create 1 number "€/m2"

Is there anyone who can help me with this? Especially the advanced filter is the hard thing to get my head arround.

Mathijs.

 

[Emperor]

I've got a new insight... I could do this with a Pivot table.. at least partially!

Now I've just have to manage the Pivottable with VBA...

The hardest I see what to do is to use a range for the date (I've got Excel 2003) How could I filter the dates?

Mathijs