Coping data

  • Thread starter Thread starter olark
  • Start date Start date
O

olark

I was wondering if there is a way to copy a value to another worksheet.


I have a cells that calculate off a pivot table. I need to save the
values into another worksheet. I can use if statements to get the value
to show, but once the pivot table changes the value will dissapear.

Any ideas?
Ian
 
The Data that I am trying to copy isn't in the pivot table, but a resul
of it. It's in a normal cell
 
If your set-up is something along these lines:

Source data > Pivot table > Extract1 > Extract2, etc

where Extract1 is calculating values read off the pivot table direct
but *without* using GETPIVOTDATA()
(maybe you're using just direct link formula?)

then the "key phrase" in your original post (to me that is):
but once the pivot table changes the value will disappear
Click to expand...

will occur

Try using GETPIVOTDATA() instead in Extract1,
then the pivot values read and calculated in Extract1 will
change accordingly with each refresh of the pivot table
 
Back
Top