Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 50
Default Copy Multiple Selections

How can I copy multiple nonadjacent selections from one work sheet to another
worksheet?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default Copy Multiple Selections

hi,
per xl, the copy command cannot be used on multiple selection.
If you have the office clipboard, you can copy up to 24 items but the copy
can only be done one at a time and paste is still a one at a time thing.
sorry.
regards
FSt1

"dford" wrote:

How can I copy multiple nonadjacent selections from one work sheet to another
worksheet?

  #3   Report Post  
Posted to microsoft.public.excel.misc
No Name
 
Posts: n/a
Default Copy Multiple Selections

As long as the top and bottom rows of the ranges being copied are the same,
copying multiple nonadjacent ranges works. Maybe you can copy some extra
stuff and delete extraneous data after it's pasted.

"dford" wrote in message
...
How can I copy multiple nonadjacent selections from one work sheet to
another
worksheet?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple selections Confuddled User!!!!!!!!!!!!! Excel Discussion (Misc queries) 3 August 30th 07 08:56 PM
How do I copy and move selections of data to other sheets? JEZ838 Excel Worksheet Functions 1 November 3rd 06 03:38 PM
copy and paste with multiple selections in Microsoft Excel capnhud Excel Discussion (Misc queries) 10 September 6th 06 08:58 PM
copy and paste with multiple selections in Microsoft Excel capnhud Excel Discussion (Misc queries) 1 September 5th 06 01:13 PM
Vlookup for multiple selections Billing Goddess Excel Worksheet Functions 7 April 10th 06 05:40 PM


All times are GMT +1. The time now is 02:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"