View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paulg[_2_] Paulg[_2_] is offline
external usenet poster
 
Posts: 1
Default code for select a group cut, paste and delete

I have a spreadsheet of multiple rows with 1 column called
status. There are 10 or 20 different statuses possible.

I have a macro that sorts the spreadsheet by status. I
want to cut the ones in "primary" status and paste them to
the end of of the spreadsheet 1 line below the last
entry. I then want to delete the rows where "primary"
status was.

Thanks

P