Moving row based on specified value VBA

I need a vba to move any ROW that has "abandon" in Column "I" to another sheet named "Missed Calls" and the results to be sorted on that sheet by Column "E'. is that possible? ill love you forever lol. my sheet1 will have 3000 rows to sort. i cant seem to add an attachment

to move any ROW that has "abandon" in Column "I" to another sheet named "Missed Calls" and the results to be sorted on that sheet by Column "E'.

Yes that is possible but your uploaded file should have an "abandon" in column I and where is the sheet named "Missed Calls"? In this file or another file?

Sorted by column "E"? What are the criteria for sorting?

Alf

Something like this

Please Login or Register  to view this content.

Very sorry. i have made corrections for u. it will be on same sheet. there is Proprietary information on the snippet so im trying to protect its integrity but i think u should get it now.

it says subscript out of range. First sheet named SHEET1 and i would like the filtered results to go to Missing Calls

Error?...................

I LOVE U! lol. is there a way to group by e with two rws of separation?

If you upload a workbook with the result that you want, it would help to understand how you exactly want it.

it did what i want. thank you. now all the results are on missed call which is fantastic. now id like Column E to sort by those values and group seperately. Im trying to get this to my main spread sheet and its not allowing.

This is how id like the page to finish

See if this is how you wanted.

Please Login or Register  to view this content.

Thank you So much!!! its what i need. Ill be back with more questions later lol