Coping data

[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

 

[Max]

Check up Excel's Help for info & examples
on GETPIVOTDATA() function

 

[olark]

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

 

[Dave Peterson]

Copy|Paste special|Values before you change the pivottable???

 

[Max]

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

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