I will automate excel reports with vba and power query
Excel and Power Query for manufacturing planning and inventory
About this Gig
Do you repeat the same Excel reporting steps every week or month?
I will automate a defined reporting workflow with Power Query, VBA or formulas, choosing the simplest approach that fits your files and Excel environment.
I can help you:
- import and combine recurring files
- clean and transform source tables
- refresh PivotTables, charts and KPI dashboards
- reduce repetitive copy/paste work
- add clear controls and handover instructions
Basic covers one focused Excel task. Standard covers up to three recurring reports. Premium is a broader multi-source reporting workflow with a dashboard and documentation. Source code is included with the delivered workbook where applicable.
Before ordering, send a redacted sample, the current manual steps, the expected report and your Excel version. Tell me whether macros are allowed. I will confirm the scope and the package that fits it.
Technology:
Excel
•
VBA
My Portfolio
FAQ
Can you automate my existing Excel file or dashboard?
Yes, I can review your existing Excel file or dashboard and add automation using VBA, Power Query, formulas, or reporting logic. If structural changes are needed, I will confirm them with you first.
Can you ensure my data remains confidential?
Yes. I treat client files and project data as confidential and do not share them with third parties. Please avoid sending unnecessary sensitive or personal data.
What do you need to start the project?
Please provide your Excel file, a short description of the task, the expected result, and any examples or screenshots that can help define the workflow.
Can you clean or merge data from multiple files (CSV, PDF, TXT)?
Yes, I can clean, combine, and organize data from Excel, CSV, TXT, and suitable PDF files using Power Query and Excel automation. PDF support depends on the file structure.
3 reviews for this Gig
| (2) | ||
| (1) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Quality of delivery
- Value of delivery
Sort By
W wojciech7777

Poland
Great work! Fast delivery, clear communication, and a perfectly working Excel/VBA solution. Highly recommend.
$50
Price
2 days
Duration
Helpful?D diana1997_

Poland
Perfect job, very fast and professional. Highly recommend!
$50
Price
1 day
Duration
Helpful?B brandqew

Slovakia
very good cooperation, I recommend!
$50-$100
Price
3 days
Duration
Helpful?
3 reviews for this Gig
| (2) | ||
| (1) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Quality of delivery
- Value of delivery
Sort By
W wojciech7777

Poland
Great work! Fast delivery, clear communication, and a perfectly working Excel/VBA solution. Highly recommend.
$50
Price
2 days
Duration
Helpful?D diana1997_

Poland
Perfect job, very fast and professional. Highly recommend!
$50
Price
1 day
Duration
Helpful?B brandqew

Slovakia
very good cooperation, I recommend!
$50-$100
Price
3 days
Duration
Helpful?

