Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference another worksheet as an output for IF formula? | Excel Discussion (Misc queries) | |||
copy from B worksheet to A worksheet with NO repeated data | Excel Discussion (Misc queries) | |||
copy data from a worksheet | Excel Worksheet Functions | |||
copy data in a cell from worksheet A to worksheet B | Excel Discussion (Misc queries) | |||
How do I output the worksheet name in cell? | Excel Discussion (Misc queries) |