*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.
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.
42 freelancere byder i gennemsnit $111 på dette job
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.
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
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
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
i can do data entry work for your project timely and you have the quality work . i have experienced in data entry work and done many projects of excel/google sheet entry.i can also convert JPG/PNG image into text .
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
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.
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,