Færdiggjort

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: 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, transfer excel data website, separate data excel rows column columns, data transfer excel, excel sheet bse nse data, vba excel sumup specific cells data, transfer excel data joomla, single cells excel javascript

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

Projekt ID: #16648368

Tildelt til:

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 på 1 dag
(247 bedømmelser)
7.0

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

$200 CAD in 3 dage
(552 bedømmelser)
8.2
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 Flere

$200 CAD in 3 dage
(253 bedømmelser)
7.3
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 Flere

$30 CAD in 3 dage
(248 bedømmelser)
7.4
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 dage
(167 bedømmelser)
6.7
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 dage
(144 bedømmelser)
6.4
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 dage
(87 bedømmelser)
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 dage
(132 bedømmelser)
5.8
bilalmaher053

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

$50 CAD på 1 dag
(130 bedømmelser)
5.8
nwss1986

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
(58 bedømmelser)
5.0
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 dage
(15 bedømmelser)
4.6
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 Flere

$222 CAD in 3 dage
(19 bedømmelser)
4.7
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 Flere

$80 CAD in 0 dage
(21 bedømmelser)
4.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 dage
(10 bedømmelser)
4.8
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 på 1 dag
(17 bedømmelser)
3.8
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 dage
(14 bedømmelser)
3.9
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 Flere

$100 CAD in 3 dage
(9 bedømmelser)
3.5
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 Flere

$77 CAD på 1 dag
(7 bedømmelser)
3.6
bPeou2017

Dear hiring manager, I am senior Excel & web scraping expert with 6 years experience in data mining. I am very good at Excel works. I have so many experience in data scraping(All Amazon products, 10M Amazon Black T-Shi Flere

$155 CAD in 3 dage
(2 bedømmelser)
2.9
$155 CAD in 3 dage
(4 bedømmelser)
2.8
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 dage
(8 bedømmelser)
2.3