Clone Rows from one sheet to the other containing

问题:

I have a "sheet1" containing several headings and i'm looking to see if there is a formula i can ran that will scan, filter only the rows whereas the Column G has the status as "open".

see example: http://s18.postimage.org/897u71lnt/excel2.png

I want all of the "Open" items to be copied on the "sheet2" automatically. Everytime that sheet1 is updated with a new issue and has Open on the G column , sheet 2 will get this values.

Is it possible to do this without VBA?

Thanks

回答1:

As @PeterL pointed out, it's not "two lines of code". However, there is a solution... I have posted a complete Excel workbook with macros at this link . It does not only what you are asking in this question, but addresses some of the questions you asked in previous comments, and has additional functionality you didn't even know to ask for (like "if a previously 'open' issue now becomes 'closed', it needs to be removed from the list of 'open' issues).