Displaying specific rows from one table in another if certain criteria is met

**wacattack** · 09-08-2011, 12:29 PM

Hi all, I have a bit of a problem I hope you can help resolve.

Basically I have data displayed in a table. Column A contains account number and column E a flag to say if the account has passed or failed. I then have another table that I want to automatically display all accounts that have the flag in column E set to "FAIL".

The information in the first table is constantly being updated therefore the information in table 2 needs to automatically acknowledge and display each entry of "FAIL".

Any advice?

Thanks
Wayne

**JBeaucaire** · 09-08-2011, 12:43 PM

If you turn on the AUTOFILTER on your main sheet, you can filter column E for "FAIL" anytime you want to just see the failed items in an organized list. The AutoFilter is designed to make the need for separate sheets less of a requirement. You filter/edit/print/whatever right in your main table as needed, then turn off the filter to see all... very convenient and much less plumbing than separate sheets.

**wacattack** · 09-09-2011, 03:48 AM

Thanks for the reply but I was hoping to be a bit more fancy than this. I was wanting to have a seperate tab that only contains the "FAILS" that links back to the primary table, rather than simply applying the filter to the primary table.

**JBeaucaire** · 09-09-2011, 08:24 AM

AutoFilter is still the way to go, of course, even if it's happening automatically for you in the background. VBA (a macro) could keep copying the FAILED items to your second sheet, you ok with that?