View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
KC8DCN KC8DCN is offline
external usenet poster
 
Posts: 5
Default Noncontiguous rows

Yes...

But it has been sorted and subtotaled. I'm trying to copy the results of
the subtotals to a new worksheet. Various transactions were done throughout
different months, which were then subtotaled. I would like to copy the
results for each of the months into a new spreadsheet.


"Dave F" wrote:

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!