Summarise Multiple Sheets into One Sheet and Filter by a value

Hi,

I currently have an excel workbook with around 20 worksheets in it that track Requests For Information. I want to consolidate each of the sheets into one sheet that only lists the rows of information that are Overdue.

Currently I have done this by referencing each value of each row on all cells on each sheet and then filtering.

Is there an easier way to do this or a way to do this that doesn't impact as much on the size of the document.

Also as I add new sheets to the workbook using the blank template, would there be an easy way to add this new sheet into the Overdue tab.

See attachment (a basic sanitized version of the document I have created and used).

Chris

You could do it with a few formulae. Here's a couple of threads from the last few days in which I show the OPs how to do it from 2 sheets into one Master sheet:

http://www.excelforum.com/excel-form...-a-master.html

and:

http://www.excelforum.com/showthread...40#post4544540

In your case, you would have a condition to identify the records like this in A13 of the subsidiary sheets:

=IF(P13="Overdue",MAX(A$12:A12)+1,"-")

Hope this helps.

Pete

Hi Pete,

Thank for those, but I'm not that knowledgable on Excel is there a way you could edit the spreadsheet to show how this works and i can then replicate.

Chris