克隆从一张纸到另一张纸的行包含值 [英] Clone Rows from one sheet to the other containing a value

问题描述

我有一个包含几个标题的sheet1，我正在查看是否有一个公式，我可以运行它将扫描，仅过滤列，而列G的状态为open。

查看示例： http：//s18.postimage。 org / 897u71lnt / excel2.png

我想要将所有打开项目自动复制到sheet2上。每当sheet1更新一个新的问题，并在G列上打开时，表2将获取此值。

是否可以在没有VBA的情况下执行此操作？ p>

谢谢

解决方案

正如@PeterL所指出的那样，的代码。但是，有一个解决方案...
我已经发布了一个完整的Excel工作簿与宏在此链接。它不仅仅是你在这个问题上提出的问题，而且解决了你以前的评论中提到的一些问题，并且还提供了你甚至不知道要求的其他功能（例如如果以前的开放问题现在变成关闭，需要从开放问题清单中删除。）

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

解决方案

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

这篇关于克隆从一张纸到另一张纸的行包含值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！