Transfer Excel rows to new sheet when single cells data in row meets criteria

*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.

Evner: Dataindførsel, Databehandling, Excel, Web Skrabning, Websøgning

Se mere: transfer excel data website, separate data excel rows column columns, data transfer excel, excel extract rows based on cell value, if column contains value then copy row to new sheet, excel copy row to another sheet if, excel macro to copy rows from one sheet to another based on condition, excel copy rows based on criteria to another sheet, excel extract rows that meet criteria, excel copy row to another sheet based on cell value, excel pull data from another sheet based on criteria, data entry, data processing, excel, web scraping, web search, business analysis, visual basic for apps, excel sheet bse nse data, vba excel sumup specific cells data

Om arbejdsgiveren:
( 3 bedømmelser ) Lachine, Canada

Projekt ID: #16648368

Tildelt til:


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.

$100 CAD på 1 dag
(282 bedømmelser)

42 freelancere byder i gennemsnit $111 på dette 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 Flere

$200 CAD in 3 dage
(626 bedømmelser)

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 Flere

$200 CAD in 3 dage
(319 bedømmelser)

Dear Hiring Manager, You may review my profile here: https://www.freelancer.com/u/motiur03.html I am writing to apply for the position of Virtual Assistant to Transfer Excel rows to new sheet when single cells da Flere

$30 CAD in 3 dage
(281 bedømmelser)

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.

$155 CAD in 3 dage
(180 bedømmelser)

I can do it for you quickly and exactly by VBA. Please contact me for saving your time and your money .

$90 CAD in 2 dage
(103 bedømmelser)

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

$155 CAD in 3 dage
(162 bedømmelser)

hi, u need excel VBA code to match word and copy row in new sheet?

$50 CAD på 1 dag
(180 bedømmelser)

Hello, I am proficient with Excel and VBA and would love to help. Please contact me for more information.

$75 CAD in 2 dage
(138 bedømmelser)

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 Flere

$80 CAD in 0 dage
(60 bedømmelser)

Hi, Your requirement can be done with the help of macro. It will automate the process and will copy appropriate rows as needed.I can do this and i can start the work right now. I can deliver within a day, probably, in Flere

$88 CAD in 0 dage
(79 bedømmelser)

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

$98 CAD in 3 dage
(24 bedømmelser)

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 Flere

$222 CAD in 3 dage
(24 bedømmelser)

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

$155 CAD in 3 dage
(32 bedømmelser)

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

$100 CAD in 3 dage
(26 bedømmelser)

I am an excel expert having a vast experience of advance excel related projects. I have got more than 11 years of professional experience. I can fulfil your requirement very efficiently meeting all your requireme Flere

$77 CAD på 1 dag
(12 bedømmelser)

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 .

$105 CAD på 1 dag
(5 bedømmelser)

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

$35 CAD på 1 dag
(19 bedømmelser)

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 Flere

$100 CAD in 3 dage
(13 bedømmelser)

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.

$50 CAD in 2 dage
(9 bedømmelser)

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,

$100 CAD in 3 dage
(2 bedømmelser)