Excel VBA expert needed
$30-250 USD
Paid on delivery
We have a folder structure with around 20-30 subfolders containing numerous excel files and jpgs in each.
The task is to analyze the folder content based on folder name (and parts thereof), number of files, change date, and data within the files. 90% is a direct cell value, but some info needs to be calculated (like number of characters in a certain cell range).
The VBA should go through the folder structure and write some 10 – 15 key info in a separate Excel file (in a table structure). The structure is user and day, i.e. we need to now the number of certain files meeting certain criteria at a given date.
On a new run eg 2 days later, any changes of users to the files in the folder structure should generate an updated table with new key data.
More detailed instructions are issued to the awarded party.
Budget is 50 to 70 USD.
We will select based on relevant experience in the field and number of reviews.
Project ID: #29048491
About the project
38 freelancers are bidding on average $71 for this job
Hi, Greetings! ✅ I have checked and gone through the project details and I am very skilled in it. ✅Completed Time: In project deadline We have worked on 640 + Projects. I have 6 + years of the experience in sa More
Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within 1 day
Hi Need more details , like ..write some 10 – 15 key ...exact meaning. I can do this via Ms Access with Excel automation. I can detail more in private chat. Best, Zurab
NOTE : I HAVE EXPERTISE IN EXCEL AND VBA. With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. I have successfully completed pr More
I am postgraduate with more than 7 years of experience in advance excel based templates and tools, MIS reporting, business automation, dynamic dashboards, VBA, Excel macros, financial modeling and data processing. Plea More
Hi, How are you? I have developed several Excel & Word VBA macros before. And I know about Excel formulas very well. If needed, I first can do a demo and send it asap. And then you can see it and decide on this project More
Hi there, I can help you with your Excel VBA project based on your requirements. I have 8+ years of expertise in Excel/VBA, SQL, Power BI, Tableau creating complex automation tools, formulas, databases, queries and More
Hi there, Give through your requirements and clearly understood what you need. I am a Microsoft Certified Professional in Excel and VBA as an Expert Kindly go through my profile. Awaiting your response and samples More
Hi, I am an excel expert, have more than 8 years working expereice. I can write perfect code for you. Lets have chat plz thanks
I can help you here, but I recommend using Python for this, not VBA. I will write you a script that will run automatically and do exactly what you are wanting. Let me know if you would like to discuss further.
Hi, I am Swarnali, available online more than 16 hours everyday. I have read your project details. Recently, I have completed the excel formula, google sheet script and excel VBA macro based projects (see in portfoli More
Hi there, I am really interested in working on your project. I will design and develop a macro that will run through you folders and capture information therein. I am available to create a macro for you that will do th More
Hi I have 10 + years of experience in VBA programming and database management. I checked the requirement and as an expert I can write a dynamic script that helps you loop through all folders , collect information and More
HI hope you doing well, I am qualified and experienced senior VBA/RPA Developer having 12+ years of experience in developing automation projects. I has done tons of projects similar to your requirement using VBA,. I c More