Closed

Excel VBA expert needed

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.

Skills: Excel VBA, Excel, Excel Macros, Visual Basic

See more: excel vba expert resume, vba expert needed, excel vba expert dashboard, salary excel vba expert, best best excel vba expert, excel vba programmer needed small projects, freelance excel vba expert switzerland, excel vba expert phildelphia, excel vba expert needed, excel maths expert needed, excel vba expert needed write application, excel vba expert needed write, need excel vba expert, excel vba expert required, excel spreadsheet expert needed, excel vba expert, vba expert needed - urgent, excel vba expert freelancer, VBA Expert needed for urg, VBA Expert needed

About the Employer:
( 24 reviews ) Leopoldsdorf, Austria

Project ID: #29048491

38 freelancers are bidding on average $71 for this job

schoudhary1553

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

$80 USD in 2 days
(406 Reviews)
8.2
(297 Reviews)
7.3
(197 Reviews)
6.7
saif12me

Hi I would love to help you to automate the Excel workbook with VBA/Macro. I'm well versed with Excel VBA/Macro, complex formulas, documents automation, data analysis, data processing, etc. I have good experience worki More

$70 USD in 2 days
(35 Reviews)
6.2
(103 Reviews)
5.9
writingapp

Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within 1 day

$60 USD in 1 day
(91 Reviews)
5.8
akritisood94

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

$140 USD in 1 day
(90 Reviews)
5.9
bhupendrayadav

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

$80 USD in 1 day
(49 Reviews)
5.8
narsim3128

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

$50 USD in 3 days
(62 Reviews)
6.0
rengrish

Hi Sir, I went through your requirement. I understand at high level Need to analyze files in folder /subfolders and produce some output. This is fairly straight requirement. I can complete this job within hour or two. More

$50 USD in 1 day
(159 Reviews)
6.0
zu02

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

$70 USD in 7 days
(40 Reviews)
5.9
ShakeelASESE

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

$70 USD in 7 days
(29 Reviews)
5.3
ravinderkumar248

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

$50 USD in 2 days
(77 Reviews)
5.4
dhanrajkarthick

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

$78 USD in 1 day
(41 Reviews)
5.2
croll12

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.

$150 USD in 4 days
(8 Reviews)
4.9
swarnali2017

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

$70 USD in 3 days
(29 Reviews)
5.1
WycOj

MACROS EXPERT Ready to start right now……………. Dear client, I can help you with your project of data entry in excel, VBA, excel macros, VB, creating buttons, excel sheets, ready to start right now, message me and let is More

$30 USD in 7 days
(26 Reviews)
4.5
mowachira77

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

$55 USD in 1 day
(35 Reviews)
4.7
ShivaniGoyalsai

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

$45 USD in 2 days
(13 Reviews)
3.5
(5 Reviews)
3.8