Forum Discussion

SRIDHAR RAMESH's avatar
SRIDHAR RAMESH
Copper Contributor
Apr 10, 2018

Auto Select data one by one from data filter of a pivot table using VBA MACROS

Hi!!!   I need some help to write a VBA macro code to auto select a data one after another from a data filter field of a pivot table.   Sheet 1 consists of all datas and Sheet 2 consists of Pivot...
Macros & VBA
Show and Tell
SRIDHAR RAMESH's avatar
SRIDHAR RAMESH
Copper Contributor
Apr 12, 2018

Dear Jan,

 

Noted.

 

Had ran both of the macros, but i am getting error.

 

Pls find the screenshots in the word doc attached for your reference.

 

Pls help to rectify it.

 

Thanks and Regards

Sridhar

JKPieterse's avatar
JKPieterse
Silver Contributor
Apr 12, 2018
For the first error: make sure the code uses the correct worksheet names.
The second I don't know, it worked for me.
  • SRIDHAR RAMESH's avatar
    SRIDHAR RAMESH
    Copper Contributor
    Apr 12, 2018

    Dear Jan,

     

    Thanks for your help.

     

    Will try this one.

     

    Best Regards

    Sridhar

Resources