I have a pivot table in A3 of a tab called "at risk". Before I can share my file, I need to delete the source values. Which means I need to replace the pivot table with just the values and formatting. I'd like to do that in the same worksheet so people using this file won't really notice anything is different, either by pasting over the current table or copying it into a new location and then deleting the original.
I've been trying to adapt Contextures' macro but there are too many commands I don't understand so I can't just make modifications for my needs.
Thanks!
I've been trying to adapt Contextures' macro but there are too many commands I don't understand so I can't just make modifications for my needs.
Thanks!