Transfer Excel rows to new sheet when single cells data in row meets criteria
$30-250 CAD
Paid on delivery
*NOTE: When reading the details, please understand that the number of rows can vary, and so can the number of keywords. However, there will never be more than 1 keyword in a row.
I routinely receive Microsoft Excel sheets, saved as comma separated values text files (CSVs) containing more than 10,000 rows with columns "A" through "AR" also containing data.
I need to quickly transfer only some of those 10,000+ rows of data to a new sheet.
Currently, If any row contains 1 of 78 keywords (a row will never contain more than 1 keyword) in column "F" that entire row needs to be copied.
I have attempted using Advanced Filter, but that has only transfer the first occurring instance matching only 1 of my keywords. Of the 78 keywords I may have 1500 matching rows.
Please send me your thoughts/questions, or your project $ estimate and timeline.
Project ID: #16648368
About the project
Awarded to:
Hello, I’m an Excel/VBA expert and I can write a macro to automatize this task. I'm fully available and I can start right away. Please check my profile and contact me to discuss. Regards.
37 freelancers are bidding on average $111 for this job
Hello Sir, Thank you for this opportunity. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering More
I would want to have a more detailed instruction for this project and would want to do a sample to evaluate better. Can start immediately..I can do this for you quickly and with great quality for cheap. ZERO ERROR More
Hello, I am ready to Transfer Excel rows to new sheet when single cells data in row meets your criteria, Please contact me for further discussion, Thanks.
I can do it for you quickly and exactly by VBA. Please contact me for saving your time and your money .
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. I have already done this kind of work and, I can do this for you in a few More
Hello there, I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss timeline and budget. Thanks A
I can write a script to do this. I would propose a text file where you can add/remove keywords which will be read by the program. It would then process the csv files and copy rows that match
Hello, I am proficient with Excel and VBA and would love to help. Please contact me for more information.
Hi,I m Omit. I understand the project requirements and willing to start as soon as possible you say to me. Looking forward to work with you. Thanks
I would love to chat to you more about this project as there are a number of ways to approach it. If you are OK with a VBA solution, then the keywords could be assigned to a dynamically sized array fo comparison (or al More
Hello, I went thru the project description Kindly send me the details and discuss You may see previous projects and reviews I am looking forward to hearing from you Thanks Regards Thushara
As an engineer in statistics and applied economics and specialized in Microsoft Office (graduated from Microsoft, I am available, capable and ready to do this kind of work in the best conditions,
Hi there, i understand your requirement and can do the work perfectly using my outstanding experience. Please award me the project so that we discuss it more Thank you.
Hi. Please see my profile for samples. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request
Hello I've read your problem and I believe the best solution would be to implement a VBA code with a loop to search for every keyword and if it is there, copy the entire row into the new spreadsheet to an empty row. Ho More
Hi i am ready toTransfer Excel rows to new sheet when single cells data in row meets criteria . my objectives is understaing with customer and satisfaction result . i will provide you 100% quality work and satis More