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

Completed Posted 6 years ago Paid on delivery
Completed 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.

Data Entry Data Processing Excel Web Scraping Web Search

Project ID: #16648368

About the project

37 proposals Remote project Active 6 years ago

Awarded to:

P0L

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 in 1 day
(478 Reviews)
8.0

37 freelancers are bidding on average $111 for this job

jaylancer43

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

$200 CAD in 3 days
(816 Reviews)
8.8
KulfiSoftwares

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

$200 CAD in 3 days
(376 Reviews)
7.9
motiur03

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 More

$30 CAD in 3 days
(409 Reviews)
8.1
Venkat2011sri

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 days
(225 Reviews)
7.4
bilalmaher053

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

$50 CAD in 1 day
(317 Reviews)
7.1
zebracaro

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 days
(120 Reviews)
7.1
periyannas

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

$80 CAD in 0 days
(152 Reviews)
6.8
avinav606lx

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 days
(168 Reviews)
6.5
DavidLindon

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 days
(47 Reviews)
6.3
vlayausa

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

$75 CAD in 2 days
(150 Reviews)
5.9
AmitHasanRaj

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 days
(39 Reviews)
5.5
katiewells3

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

$222 CAD in 3 days
(32 Reviews)
5.4
nelumindralal

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 days
(36 Reviews)
5.1
Statxn

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 days
(16 Reviews)
4.3
avidusman

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 More

$77 CAD in 1 day
(12 Reviews)
4.3
Nicecreator

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 days
(12 Reviews)
3.7
huongth

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 in 1 day
(19 Reviews)
4.2
SousaTranslation

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

$100 CAD in 3 days
(15 Reviews)
3.9
Lirpa12

A proposal has not yet been provided

$30 CAD in 1 day
(2 Reviews)
1.1
RizwanaNawaz

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

$155 CAD in 3 days
(1 Review)
0.0