You're welcome.

Pete

On Sep 11, 3:12 pm, Astroboy
wrote:
GREAT~~!!!

Thanks for everything and have a great week....!!!!



"Pete_UK" wrote:
Thanks for feeding back - glad it worked for you.

To disable the reduced menu feature, click on Tools | Customise |
Options and uncheck the option "Menus show recently used commands
first", then click Close.

Hope this helps.

Pete

On Sep 10, 10:48 pm, Astroboy
wrote:
Oh... Great and it works....!!1

Thanks......

P.S. do you know how to Disable the AUTO COLLAPSE on Menu (ex. On Edit,
File,.. Etc) ?

"Pete_UK" wrote:
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- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -