You can make it a Dynamic Range
http://www.contextures.com/xlPivot01.html
Then use this to auto refresh when the sheet tab is selected
http://www.vbaexpress.com/kb/getarticle.php?kb_id=80
HTH
VBA Noob
You can make it a Dynamic Range
http://www.contextures.com/xlPivot01.html
Then use this to auto refresh when the sheet tab is selected
http://www.vbaexpress.com/kb/getarticle.php?kb_id=80
HTH
VBA Noob
_________________________________________
![]()
![]()
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks