En cours

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, 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

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

N° du projet : #12677317

Décerné à :

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

17 freelance ont fait une offre moyenne de 59 $ pour ce travail

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 Plus

34 $ USD en 1 jour
(391 Commentaires)
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 en 1 jour
(322 Commentaires)
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 Plus

70 $ USD en 1 jour
(83 Commentaires)
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 en 1 jour
(59 Commentaires)
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 Plus

60 $ USD en 0 jours
(47 Commentaires)
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 Plus

20 $ USD en 1 jour
(39 Commentaires)
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 en 7 jours
(8 Commentaires)
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 en 0 jours
(15 Commentaires)
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 en 2 jours
(7 Commentaires)
3.7
22 $ USD en 1 jour
(14 Commentaires)
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 Plus

40 $ USD en 1 jour
(5 Commentaires)
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 Plus

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

388 $ USD en 1 jour
(1 Commentaire)
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 en 1 jour
(0 Commentaires)
1.0