Code VBA for Excel

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 软件构架 Visual Basic

项目ID： #1478419

关于项目