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.

Compétences : Excel, Visual Basic

Voir plus : macro excel merging rows, input output macro excel, excel input output macro, macro input output data excel, excel macro data input output, macro excel convert rows column, excel macro input output file, macro excel incremental input output, excel macro input output, excel macro file input output, file input output macro excel, excel macro simple input output, excel input output, input output function example problem code mips, remove add macro excel, excel macro user input drop menu, macro excel filling rows, excel macro require input drop list, macro excel input data, data mining macro excel, copy next cell macro excel, copy website macro excel, macro excel string manipulation, macro excel open sort output, show print macro excel

Concernant l'employeur :
( 12 commentaires ) Severna Park, United States

N° du projet : #12677317

Décerné à :


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 [url removed, login to view]!!

25 $ USD en 0 jours
(21 Commentaires)

17 freelance font une offre moyenne de $59 pour ce travail


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 Plus

34 $ USD en 1 jour
(391 Commentaires)

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 en 1 jour
(322 Commentaires)

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 Plus

70 $ USD en 1 jour
(83 Commentaires)

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 en 1 jour
(59 Commentaires)

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 Plus

60 $ USD en 0 jours
(47 Commentaires)

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 Plus

20 $ USD en 1 jour
(39 Commentaires)

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 en 7 jours
(8 Commentaires)

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 en 0 jours
(15 Commentaires)

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

50 $ USD en 2 jours
(7 Commentaires)
22 $ USD en 1 jour
(14 Commentaires)

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 Plus

40 $ USD en 1 jour
(5 Commentaires)

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 Plus

30 $ USD en 1 jour
(6 Commentaires)

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 en 1 jour
(4 Commentaires)
25 $ USD en 1 jour
(4 Commentaires)

Hi, I am Google Spreadsheet automation expert. I have good experience in formulas and Programming. [url removed, login to view] I have completed many projects successfully and very similar Plus

388 $ USD en 1 jour
(1 Commentaire)

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 en 1 jour
(0 Commentaires)