Code VBA for Excel

Completed Posted Mar 1, 2012 Paid on delivery
Completed Paid on delivery

Background :i have an excel database with a high number of sheets (50 to 100 sheets). You will have to write a macro which has to do two major operations ;

1. delete sheets in which the value found on the last row / column B is smaller than a specific value. The user should have the option to define this specific value via a message box dialogue.

2. From the remaining sheets, the macro should extract values in row (C to L column) for a dependent variable and make the average for these variables found across remaining sheets. The averages have to be appear in a separated new worksheet.

A detailed brief of the project will be provided to the winner of the job.

PHP Software Architecture Visual Basic

Project ID: #1478419

About the project

6 proposals Remote project Active Mar 2, 2012

Awarded to:

pyazlm

I can provide a macro in VBA.

$30 USD in 2 days
(17 Reviews)
3.8

6 freelancers are bidding on average $93 for this job

barundebnath

Hi, I am VBA expert. Send me details. Thanks

$150 USD in 10 days
(32 Reviews)
5.4
Teloquence

Consider it done. Check your PM.

$100 USD in 0 days
(11 Reviews)
4.0
guevanjr

Please consider my bid. High quality work and timely delivery is assured. Thanks, SG

$100 USD in 0 days
(3 Reviews)
2.1
MohamadShrayteh

Let us do it.

$80 USD in 2 days
(0 Reviews)
0.0