Hey Guys,
I have a file that pulls data sets from SQL one Data set runs the sub ‘Filter’ fine to filter the pivot, but when I pull in the second data set from the same Table in SQL Database but a different filter on ‘Plant_sys’ (SQL) it does not work.
Pivot table filter Sub, the Value in R1 is updated by a double click
I tried manually recording myself filtering the pivot table, but when I try to run the recording I get the Run-time error '1004'Please Login or Register to view this content.
Please Login or Register to view this content.
I have Also attached sample Data from both SQL Queries Tab labeled ‘Issue Data’ is the one where the pivot Sub ‘Filter’ is not working nor the Manually recorded Sub ‘Macro3’
Tab labeled ‘Working Data’ is a small sample of the working table
I have been trying to figure the issue out for hours, any and all help is appreciated.
Pivot table where the Sub should update the filter
Capture.PNG
I hope i am not adding too much to the post, but when i load the data set where it does not work i get the following when running the filter Sub
Run-time error '424':
Object required
on this line on the Filter Sub
Please Login or Register to view this content.
Bookmarks