Will do, and I'd appreciate that. If I can get this to work, it will
save a chunk of time and improve quality for folks in my department
(because they won't need to look at a catalog number on one sheet,
then go to the other sheet and fat-finger it in.
Here is a link to the workbook in my DropBox account. Thanks very
much Garry!
https://www.dropbox.com/s/3ykj12489z...Keys.xlsm?dl=0
On Mon, 09 Apr 2018 16:29:20 -0400, GS wrote:
Maybe the property setting you need to use is "DrilledDown" instead of
"Visible". I can't play around with this not having a pivot table to work
with; -post a download link to your file if you'd like me to see if I can
figure something out...
Got it!
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion