You will get a fantastic Excel VBA automation solution to save you time and money

You will get a fantastic Excel VBA automation solution to save you time and money

Project details
I will examine your excel data and visual basic for applications (VBA) code to fix, optimize to run faster, and provide the expected outcome. Worksheet duplication, invoice creation, bill printing, inventory management.
I will automate excel tabular data processing based on a set of rules and requirements with your test files.
The final delivery will contain the processed test data and commented source codes in the file so that you can examine, test, assess the outcome, and validate the result. If you want, I will deliver macro source codes as separate files for archiving purposes or reuse them for other files and adaptations.
If you require error traps, I will add them for possible points. The source code will contain English or Turkish comments to be explanatory.
You can contact me for future changes and adaptation, and I will be happy to assist.
If your files use add-ins and components, you should follow up on version updates. I can help with this also.
Data types are so crucial in excel files and for correct data manipulation. For logical separations and layered design, I can add file and folder operations. Eliminating manual tasks can save you precious time.
I will automate excel tabular data processing based on a set of rules and requirements with your test files.
The final delivery will contain the processed test data and commented source codes in the file so that you can examine, test, assess the outcome, and validate the result. If you want, I will deliver macro source codes as separate files for archiving purposes or reuse them for other files and adaptations.
If you require error traps, I will add them for possible points. The source code will contain English or Turkish comments to be explanatory.
You can contact me for future changes and adaptation, and I will be happy to assist.
If your files use add-ins and components, you should follow up on version updates. I can help with this also.
Data types are so crucial in excel files and for correct data manipulation. For logical separations and layered design, I can add file and folder operations. Eliminating manual tasks can save you precious time.
Data Tool
Microsoft Excel$50
- Delivery Time 4 days
- Number of Revisions 2
- Number of Macros 4
- Number of Buttons/Forms 3
- Model Documentation
- Data Source Connectivity
- Toolbar Integration
Optional add-ons
You can add these on the next page.
Fast 3 Days Delivery
+$30
Additional Revision
+$30Frequently asked questions
5 reviews
(4)
(1)
(0)
(0)
(0)
This project doesn't have any reviews.
TJ
Taras J.
Jan 28, 2025
National minimum wage calculation
Our 3rd time working with Serkan and a pleasure as always. He was fast, effective and delivered another great macro that helps us understand if that our staff are being paid above the NMW each month. A difficult set of input data with some interesting challenges but Serkan understood and delivered as usual. Highly recommend.
TJ
Taras J.
Nov 26, 2024
Staff Travel Claim Macro
Serkan worked on an Excel Macro for us importing files from a directory and manipulating the data. Second contract with this guy, was an excellent service, very quick, excellent communication and delivered exactly what we wanted. 10/10
VN
Vedat N.
Sep 27, 2024
Mysql Performance Tuning
TW
Tilo W.
Apr 1, 2024
Expert DBA for Exciting Project Needed
FB
Fy B.
Feb 2, 2024
Excel VBA Coding Project
good
About SERKAN
Software architect, solution provider, DBA
100%
Job Success
Istanbul, Turkey - 3:34 pm local time
If you have a problem to solve, you are in the right place. I first examine and assess the current situation and learn the expected outcome, define the gap between, empathy, design, prototype mvp, simulate user experience, plan, document and action by design thinking perspective.
I studied electronics in University, and designed embedded software by assembly language, Turbo C, Basic.
I have more than 20 years of professional experience in software development and databases. I have expertise on 8086 assembly, Basic, visual basic v1 to v6, visual basic.net, VBA, c#, asp.net, html, css, asp 2.0+, database development and administration of SQL Server, IBM DB2, mySQL, PostgreSQL. I have been MCP, MCT and MCDBA certified since 2002.
I also have extensive experience of writing complex T-SQL queries, stored procedures, triggers, functions, query optimization, detection of possible sql injection points to secure systems, and advising development teams for secure by design development.
Database and technology are at the heart of every high-value business process. Every organization needs smooth running operations and to provide such a service, they need stable software and database, DBA help for its continuous availability as it is a necessity for business.
Remote Database Administration is the perfect solution for organizations that require additional help or complete active management of their SQL database. I provide reliable technical expertise, a highly responsive service, and absolute assurance to meet your quality expectations.
I can also provide insights from your data to make your operations more efficient, sustainable and scalable. I designed and implemented several high volume telecom applications and dashboards.
My core principles
📌 Communication 📌 Quality ✔️ Consultancy ✔️ On-time ✔️ On-budget ✔️ Support
Some skills:
✔️ Back-end Development (XML, SOAP, WCF, RESTful APIs, Services)
✔️ Database design, performance tuning (SQL, TSQL)
✔️ MS SQL Server, IBM DB2, MySQL, PostgreSQL
✔️ Client/Server Applications (TCP, UDP, Sockets)
✔️ Fraud prevention, detection, cyber security readiness.
✔️ API Integration
✔️ Serial Port Communications
✔️ RPA, Automation Scripts (Scraping)
✔️ Excel VBA (Macros)
✔️ Fixing, upgrading old VB6 projects to VB.Net/C# projects (Desktop, UWP, WPF, Web)
Steps for completing your project
After purchasing the project, send requirements so SERKAN can start the project.
Delivery time starts when SERKAN receives requirements from you.
SERKAN works on your project following the steps below.
Revisions may occur after the delivery date.
Project deliverable definition and handshake
I will chat and understand to clarify your expectation to align, and we both will be on the same page about the outcome.