CODEWITHSUNDEEP
vbaexcelclone
Slider105
Slider105

Reputation: 45

Clone Rows from one sheet to the other containing a value

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

Upvotes: 0

Views: 571

Answers (1)

Floris
Floris

Reputation: 46365

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).

Upvotes: 1

Related Questions