Move Row to another sheet based on criteria

[karmaimages]

I'm looking for some help moving some data around in a workbook.

I need to analyse some data to find characters causing issues when importing into another program.

The data needed to analyse is held on sheet "Address Original" in starting in Row 2 (Headers in row 1)

I want it to move any row with the following characters , ' ; - ! in to another sheet called "Errors".

Errors sheet will have headers in row 1 same as the Address Original sheet.

The workbook has approx. 800,000 rows of data.

Any help would be appreciated.

 

[alansidman]

Could the special characters be in any column or are they restricted to a particular column? If in multiple columns, how many columns do you have?

 

[karmaimages]

Could the special characters be in any column or are they restricted to a particular column? If in multiple columns, how many columns do you have?

Hi Thanks for getting back to me,

They could be in any column and the data is in columns A - M

Cheers

 

[alansidman]

See my response at ExcelForum

Alan

 

[Joe4]

Cross-Posted: https://www.excelforum.com/excel-programming-vba-macros/1208408-move-row-based-on-criteria.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.