View Single Post
  #19   Report Post  
Posted to microsoft.public.excel.programming
Phrank Phrank is offline
external usenet poster
 
Posts: 153
Default Pivot Table run-time error 1004 (PivotField class)

Will do. That site did have a lot of great info! Thanks again!

On Wed, 11 Apr 2018 00:03:19 -0400, GS wrote:

Hi Garry,

Agreed. I really appreciate you taking a look and trying. In the
meantime today, I had a thought for a sort of work around. It's not
perfect, but it's close. I'm still using the double-click event on
the Output sheet, which is putting the selected catalog number into a
variable, switching to the slicer sheet, putting that variable into a
specified cell, and the copying that cell to the clipboard. Then the
user doesn't have to remember or fatfinger in the number, but rather
just select the pivot table drop down and paste into the search field.
It works.

Again, THANK YOU for all your time and attention to my issue!

Frank


Interestingly, I was looking at a Contextures solution that does something
similar via a userform. You might want to persist checking that site out...