View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JMB
 
Posts: n/a
Default copy avg results

Copy, then Edit/Paste Special - values


"worduser" wrote:

I have calculated average using the average function, I want to copy those
results to another worksheet, but when I copy the number it comes up as #REF!
in the cell of the new worksheet. How do I copy the results to another
worksheet? I use Excel 2000