+ 16 others have already sent a proposal.
Experience Level: Entry
Estimated project duration: 1 day or less
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. The errors could occur in any column with data from column A-M
Jason A.100% (1)
17 Nov 2017
Create an account now and send a proposal now to get this project.Sign up
Clarification Board Ask a Question
Do you still need someone on this ?
Do you want to copy the entire cell to new sheet if in any column following exist ' ; - !