Fix a VBA code to run through multiple Excel files to do a specific action
$10 USD
S-au achitat serviciile după ce au fost prestate
I need a vba code to do the following actions on multiple excel files in a specific directory:
1- when I run the code, a msgbox appears to select the directory where i have my excel files
2- then, I need the code to go through sheet2 in each file inside the directory and sub-directories to check if the date inside range1 is greater than 30/06/2015
3-if the date is greater than 30/06/2015, then clear this cell (not the row)
4-Go to range2 check if the date is greater than 30/06/2015, if true clear this cell
5- then, if the cells in range1 and range2 empty, make the corrosponding cell in range3 empty.
6- show msgbox of how many excel files were checked
I will need to do the same thing again, but the date would be 31/08/2015
I attached two files:
- the first is a sample of the excel files i will run the required code for.
the yellow shade area are the effected cells, column "N" represent range1, column "O" represent range2, and column "W" is range3.
if the date in cell "N11" and "O11" are greater than 30/06/2015, empty cell, otherwise keep information.
why i need this code? I need this to get the percentage of range 3 once before 30/06/2015 and another before 31/08/2015 and i will have to do the same things on multiple excel files.
-the second a code I downloaded from the internet to protect and unprotect multiple excel files and worked like a charm for me
ID Proiect: #9134935
Detalii despre proiect
Acordat lui:
I have seen the excel sheet you attached, basically you want to cleanup cells not meeting the criteria and based on that percentage cells will be cleaned up. I will give you a test run VBA
10 freelanceri plasează o ofertă medie de 40$ pentru proiect
Dear, Regarding my qualifications, I hold a Master's degree in Electrical Power Systems and a Bachelor's degree in Engineering (Electrical) and I've been using Matlab/Excel/VBA for 5+ years. Regarding The project: I Mai multe
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 projects.
Hi there My name is Redouane I am very interested in your project. Kindly start messaging so we can discuss further details. Thank you
Hi I'm an expert in MS technologies (VBA, Excel, Net) The required vba code is very simple and can be deliverable in a few hours Regards Carlos
I am Engineer and i know about VBA and excel. I development very codes of VBA in excel. For example matrix management.
I will try to do it within short time as i am motivated person & can understand urgency as well as i can able to help you in attractiveness of the project
