I will automate your excel reports and estimates with vba macros or python
Python developer: AI chatbots, automation, scrapers
About this Gig
Spending hours every week on the same Excel routine? I will turn it into one click.
I am a mechanical engineer who writes code, so I know estimates, bills of quantities, price lists and technical reports from the inside, not only the formulas.
What I build:
- VBA macros: import, clean, calculate, format and export (PDF/Excel) automatically
- Estimate and quotation tools: pick items, quantities and rates, get a ready quote
- Monthly/weekly reports from several files or sheets into one summary with charts
- User forms and buttons so colleagues can use the tool without touching formulas
- Fixing and speeding up slow or broken macros and formulas
- When Excel is not enough: Python (pandas, openpyxl) or Google Apps Script
What you get:
- A working file (.xlsm/.xlsx or Google Sheet) tested on your real data
- Clean, commented code and a short guide
- Free fixes for the agreed scope after delivery
Please message me before ordering with a short description and, ideally, a sample file (dummy data is fine). I will confirm the approach and the right package.
Platform:
Excel
•
Google Sheets
•
VBA
Development technology:
VBA
•
Google Apps Script
•
Python
Expertise:
Fixing
•
Forms
•
Formulas
•
Macros
•
Dashboard
My Portfolio
Other Data Processing Services I Offer
FAQ
Do you work with my existing file?
Yes. Most jobs start from your current workbook. I keep your layout and formats and only change what is needed.
VBA or Python: which is better for me?
VBA is best when everything stays inside Excel and colleagues just click a button. Python is better for large data, many files or web/API sources. I will suggest the simpler option.
Will it work on Mac or in Excel Online?
VBA works in desktop Excel for Windows and, with some limits, on Mac. It does not run in Excel Online; for that I can use Office Scripts or Google Sheets with Apps Script.
Is my data confidential?
Yes. Your files are used only for your order. You can also send a copy with dummy data instead of real figures.
Can you help with construction or engineering estimates?
Yes, this is close to my background: bills of quantities, rate build-ups, material take-offs and quotation templates.
