在Excel下拉选择中更改事件更改数据透视表 [英] On Excel dropdown selection change event change Pivot table

问题描述

大家好，
我在excel中有一个下拉列表，我想更改数据透视表的选择更改，但是与此相关的任何事情也会有所帮助，有人可以告诉我如何使用宏进行此操作.
为此，我需要一小段vb代码.
顺便说一下，我有从访问数据库中填充的excel2007.

Hello guys,
I have a dropdown list in excel and i want to change the pivot table on its selection change but anything related to this will also help, can anyone tell me how can I do this using macros.
I need a small piece of vb code for doing this.
By the way I have excel 2007 which i am populating from access db.

推荐答案

如果您在MS Excel中工作，则不需要任何宏. .您需要创建数据透视表(工具"->数据透视表"和数据透视图"/从波兰语翻译/翻译)，并创建内置在其中的数据透视图.当您更改数据透视表中的任何内容时，数据透视图将被更改.

If you are working in MS Excel... you don''t need any macros. You need to create pivottable (Tools->PivotTable and PivotChart /translate from polish language/) and create pivotchart built in on it. When you change anything in pivottable, pivotchart will be change.

这篇关于在Excel下拉选择中更改事件更改数据透视表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！