Excel Macro
- or -
Post a project like this2328
£6(approx. $8)
- Posted:
- Proposals: 19
- Remote
- #1785215
- Awarded
MS Excel, SPSS, AMOS, R, STATA, Power BI, Tableau - Data Analyst, research and insights and Creative Writing
Islamabad
Excel and VBA expert. Professional OCR. PDF to Excel Conversion. Data management, Translations English Russian
Hua Hin
11141281104630103191091723964986520827050666
Description
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)Projects Completed
1
Freelancers worked with
1
Projects awarded
36%
Last project
17 Nov 2017
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification 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 ' ; - !
538844538385
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies