本文介绍了自动过滤器宏的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好,
我有一个场景,我需要从另一张纸上过滤一张纸张数据。请找到
,我想要突出显示sheet1计数列,然后点击问题按钮然后自动过滤工作表2数据并显示工作表2.两个工作表的共性是问题关键字
列。我在很多方面尝试过,但无法实现它。任何帮助都非常感谢。
I have a scenario where I need to filter one sheet data from another sheet. Please findattached 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
推荐答案
这篇关于自动过滤器宏的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!