karmaimages
Board Regular
- Joined
- Oct 1, 2009
- Messages
- 112
- Office Version
- 365
- Platform
- Windows
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.
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.