Paste Special

[Guest]

I am conducting a survey in which I report the average "agree" & "disagee"
response percentage for an entire group and various subgroups - for both
individual questions and topics. I would like to use the same reporting
table for each analysis. I am able to generate the data by embedding the
formula in the reporting table, sorting the entire data set and deleting the
unwanted cells, but how do I print/copy/send the table without the related
data set? Being able to paste special both the format and value together in
a newworksheet would be a solution but Excel doesn't seem to permit this.
Any suggestions?

 

[Frank Kabel]

Hi
what happens if you try to copy this way (as this should work)