自动过滤器宏 [英] autofilter macro

问题描述

大家好，

我有一个场景，我需要从另一张纸上过滤一张纸张数据。请找到
附加的电子表格，我想要突出显示sheet1计数列，然后点击问题按钮然后自动过滤工作表2数据并显示工作表2.两个工作表的共性是问题关键字
列。我在很多方面尝试过，但无法实现它。任何帮助都非常感谢。 

I have a scenario where I need to filter one sheet data from another sheet. Please find attached spreadsheet, where I'm looking to highlight sheet1 count column and then click issues button which will then auto filter sheet 2 data and show up sheet 2. The commonality of both sheets is issue key column. I have tried in many ways but couldn't able to achieve it. Any help is highly appreciated. 

电子表格链接：http：//www.rapidshare.com.cn/PYSt2Vf

spreadsheet link: http://www.rapidshare.com.cn/PYSt2Vf

谢谢。

- 请标记正确答案

- please mark correct answers

推荐答案

这是提出这个问题的正确论坛吗？

Is this the right forum to ask this question?

这篇关于自动过滤器宏的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！