*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.
46 freelancere byder i gennemsnit $114 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
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 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. 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 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
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.