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

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

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


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 Αξιολογήσεις)

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


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 Αξιολογήσεις)

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 Αξιολογήσεις)

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 Αξιολογήσεις)

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 Αξιολογήσεις)

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 Αξιολογήσεις)

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 Αξιολογήσεις)

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 Αξιολογήσεις)

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 Αξιολογήσεις)

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 Αξιολογήσεις)
$22 USD σε 1 μέρα
(14 Αξιολογήσεις)

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 Αξιολογήσεις)

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 Αξιολογήσεις)

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 Αξιολογήσεις)
$25 USD σε 1 μέρα
(4 Αξιολογήσεις)

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 Αξιολόγηση)

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 Αξιολογήσεις)