Excel: Dynamic summary page

[aconybeare]

Excel:

I'm trying to create a dynamic summary page, which holds the values of all records, which have a status of "open".
All work sheets have the same number of columns, but I don't know how many rows or worksheets there will be.

If I change the status from "open" to "closed" I want the row to be automatically removed from the list and vice versa.

Any help will be greatly appreciated

Regards Al

[opus]

Whow would the file be file exactly? Where would be the "open" or "Closed" Value be placed.
I guess it wouldn'T be much a problem if you would allow only on set of columns on each worksheet.

The get the sum use the function "SumIf" (I hope thats the correct english name, in German it's "SummeWenn" )
In order to make the displayed sum dynamic, use the _change Event to reasign the area from which the SumIf is taken.

[aconybeare]

Opus,

Thanks for your response.

Yar, Every worksheet will have the same format i.e./e.g. the same layout / number of columns and column order, by that I mean that the status column will always be in 'J' regardless of which worksheet it's in.

The values open, closed etc. will be selected from a drop down list box

Cheers Al