E
E.S.
I have a large table of data generated from multiple replicates of output. I
usually use the autocalc feature in a pivot table or chart and only examine
the averages over all of the replicates. While this is nice in pivot tables
and charts, I would like to export these average values to a text file. Is
there any way to only export these calculated values into a text file without
having to highlight and paste from the pivot table view? I would also like
to use VBA so I can automate this process. Can anyone offer any advice?
usually use the autocalc feature in a pivot table or chart and only examine
the averages over all of the replicates. While this is nice in pivot tables
and charts, I would like to export these average values to a text file. Is
there any way to only export these calculated values into a text file without
having to highlight and paste from the pivot table view? I would also like
to use VBA so I can automate this process. Can anyone offer any advice?