The general answer is "not directly". But there is a workaround.
There are four scenarios, based on two conditions:
1. The source data is scattered, but it is in a region that is
*otherwise empty* except for the data that you want to copy
*AND*
The destination is a currently-empty area.
- This one is easy, just copy a single contiguous range that includes
all the source data you actually want, and paste it in the destination area.
2. The source data is scattered among other data; you only want to copy
some of it
*AND*
The destination is a currently-empty area.
- This one is also easy, but not a single step: Copy a single contiguous
range that includes all the source data you really want (and possibly
other data that you don't want), paste it into the destination area,
then delete the data you didn't want to copy.
3. The source data is scattered, but it is in a region that is
*otherwise empty* except for the data that you want to copy
*AND*
The destination is *not* empty; you only want to overwrite certain cells
with new data from the source area, and you want other data in the
destination area to remain undisturbed.
- Select and copy a single contiguous range that includes all the source
data you actually want.
- Select the destination area you want to copy into.
- Now do Edit->PasteSpecial->SkipEmptyCells.
4. The source data is scattered among other data; you only want to copy
some of it
*AND*
The destination is *not* empty; you only want to overwrite certain cells
with new data from the source area, and you want other data in the
destination area to remain undisturbed.
- The procedure here is a combination of 2 and 3.
- First copy a single contiguous range containing all the source data
you really want, and paste it into some temporary blank region. Go
through the temporary region deleting out the data you didn't really
want to copy.
- Now copy (or cut, since you probably won't be needing the temp region
afterwards) the temporary region, which is empty except for data that
you really want to copy, and Paste Special into the real destination region.
PasteSpecial->SkipEmptyCells works just like a normal Paste if you
select a destination range bigger than the source range: It repeats the
source data in the destination range. This can achieve some very useful
results.
Kirill S. Palagin wrote:
Hello.
Is there a way to copy noncontinuous selection? I can select
noncontinuous cells just fine, but Copy command is not available.
Thanks a lot.
WBR,
K. Palagin.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
