Σε Εξέλιξη

Excel macro: Remove all rows that are not needed.

Process all .xlsx files in directory c:process these:\

Remove any row that contains the following in column with header "Status" or "status": "no", "n", or blank

must be able to run on larger data sets (100Mb+ excel files)

example input and output files attached.

Must include all final unlocked, non password protected, source code.

Δεξιότητες: Excel, Visual Basic

Δείτε περισσότερα: macro excel merging rows, input output macro excel, excel input output macro, excel macro input output, excel input output, remove add macro excel, macro excel filling rows, macro excel input data, data mining macro excel, copy website macro excel, macro excel string manipulation, show print macro excel, install macro excel, vba macro excel unicode, query macro excel, macro excel cells

Σχετικά με τον Εργοδότη:
( 12 αξιολογήσεις ) Severna Park, United States

ID Εργασίας: #12677317

Ανατέθηκε στον/στην:

nwss1986

Hi.I can start right now and can deliver to you in a couple of hours.i will send you full code along with explanations, wherever necessary.Thanks!!

$25 USD σε 0 μέρες
(21 Αξιολογήσεις)
3.7

17 freelancers κάνουν προσφορές με μέσο όρο $59 γι' αυτή τη δουλειά

jaylancer43

Hello Sir, 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 Graduate with an MBA degree. If you see I am among Περισσότερα

$34 USD σε 1 μέρα
(391 Αξιολογήσεις)
7.7
cgullapalli

Hi, I am good at Excel and vba. Plz provide me the output file details further to get the scope of work. Looking forward to discuss in the chat.

$34 USD σε 1 μέρα
(322 Αξιολογήσεις)
7.1
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Περισσότερα

$70 USD σε 1 μέρα
(83 Αξιολογήσεις)
5.6
macroPOL

Hello, I am Excel and VBA expert. I can complete this project. Please note that I have 100% completion rate and 5-star feedback on 50 projects.

$30 USD σε 1 μέρα
(59 Αξιολογήσεις)
5.5
sangwanpankajs

hello sir i can do this task with formulas and if possible by macros ... i bid $60 because it will much time to get this done i am an expert in excel and have completed many tasks till now in it with excell Περισσότερα

$60 USD σε 0 μέρες
(47 Αξιολογήσεις)
4.8
ksriniravi

Greetings! Output file attachment missing! Never mind, the requirements are crystal clear. I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automa Περισσότερα

$20 USD σε 1 μέρα
(39 Αξιολογήσεις)
4.9
sayeed57590

I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start and finish it FAST.

$100 USD σε 7 μέρες
(8 Αξιολογήσεις)
4.2
sandroshubladze

Hi, I am Excel expert and VBA programmer I can write a macro for you to run it and remove anything you need from whatever you need PM me if interested Thanks & Regards

$20 USD σε 0 μέρες
(15 Αξιολογήσεις)
4.1
ksinghrajeev

Hi, I can do this for you. Award this project to me and I will deliver this work as mentioned. Thanks, Rajeev

$50 USD σε 2 μέρες
(7 Αξιολογήσεις)
3.7
$22 USD σε 1 μέρα
(14 Αξιολογήσεις)
3.5
arranmercer

Hello, I am able to create this in VBA, using a looping if statement. the if statement will delete the row if the cell in your chosen column = "no" or "n" or is blank. let me know if you would like more details on h Περισσότερα

$40 USD σε 1 μέρα
(5 Αξιολογήσεις)
3.3
techiestiffy

I will create a small application that will scan that directory and process all the xlsx file present there and then from each file remove the unwanted row. You can run the application whenever you want. Thanks, Am Περισσότερα

$30 USD σε 1 μέρα
(6 Αξιολογήσεις)
3.0
RAHUL007A

Please do pm me sir for discussing on project front, i can surely help you for the details given in project. Please do message me , waiting for your reply.

$30 USD σε 1 μέρα
(4 Αξιολογήσεις)
2.4
$25 USD σε 1 μέρα
(4 Αξιολογήσεις)
1.8
whitehatseom

Hi, I am Google Spreadsheet automation expert. I have good experience in formulas and Programming. http://screencast-o-matic.com/watch/cbVVlPQxKG I have completed many projects successfully and very similar Περισσότερα

$388 USD σε 1 μέρα
(1 Αξιολόγηση)
1.1
osmemon

I have 5 Years of Experience at Excel Macros. I have worked for several renowned organizations. Hire me for quality and quick delivery of project.

$30 USD σε 1 μέρα
(0 Αξιολογήσεις)
1.0