Copy data output only to new worksheet.
 

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

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

Copy data output only to new worksheet.
 

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

Copy data output only to new worksheet.
 

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 -

Copy data output only to new worksheet.
 

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 -

Copy data output only to new worksheet.
 

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 -