View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default Noncontiguous rows

You can sort the table by whatever relevant criteria you are using to
manually select the rows, copy and paste.

"KC8DCN" wrote:

Hello...

Is there an easy way to select noncontiguous rows in a worksheet, copy them
and paste them into another worksheet?

I know you can CTRL click through the rows, but I have over 100 rows to do
this on.

Any help would be appreciated.

Thanks!