In article , Terry Pinnell wrote:
Using Excel 2000 I copy/pasted selected non-contiguous data (with the Ctrl
key), but all the intervening cells were copied too!

https://dl.dropbox.com/u/4019461/Exc...yingPuzzle.jpg

Try using the filter function instead (worst case, an index column with "1"
in where you want to copy the row will work). Filter, copy, paste. Done. :)