Copy data output only to new worksheet.
Instead of doing <copy, move to other sheet, <paste, do <copy, move
to other sheet, then Edit | Paste Special | Values (check) | OK then
<Esc.
Hope this helps.
Pete
On Sep 10, 9:10 pm, Astroboy
wrote:
Hello all,
In Worksheet #1
-------A----------B--------------------------------------------------------*---C--D--E
1--- Text1------Data output 1 (from If function) Ex. 85
2--- Text2------Data output 2 (from If function) Ex. 90
--
--
20-- Text20-----Data output 20 (from If function) Ex. 150
And when I copy from A1 to B20 and Paste on New worksheet, it only shows 0
on B row
How can I copy only Data output and paste on new worksheet without copying
whole worksheet?
Thank you
|