Looking for an Excel Expert
Budget: $30 – $250 USD
I have several workbooks where raw data is pasted in daily, and I’m tired of spending time re-formatting each sheet by hand. I need a VBA macro that steps in the moment new rows are added, checks their structure, then applies the exact formatting and layout rules I already follow manually. Think of column widths, number formats, header styles, conditional colouring, and the occasional re-ordering of fields so the file is always presentation-ready without a single click.
Scope
The job is strictly about automating data-entry tasks—no analytics or formula building this time—so please focus your effort on a clean, reliable macro. The macro should run inside Excel (365 desktop) and be delivered as unlocked code so I can adjust ranges later if needed.
Deliverables
• A single, well-commented VBA module that:
– Detects when new data is pasted or imported
– Validates column count and header names
– Applies all formatting and organising rules automatically
• A short read-me inside the workbook describing how to trigger or schedule the macro
Acceptance
I’ll consider the task complete when I can drop a fresh data dump into the sheet, press one button (or rely on Worksheet_Change), and see the file instantly match the template I’ll provide.
If this sounds straightforward to you and you have a track record with VBA automation, let’s get it done.
Scope
The job is strictly about automating data-entry tasks—no analytics or formula building this time—so please focus your effort on a clean, reliable macro. The macro should run inside Excel (365 desktop) and be delivered as unlocked code so I can adjust ranges later if needed.
Deliverables
• A single, well-commented VBA module that:
– Detects when new data is pasted or imported
– Validates column count and header names
– Applies all formatting and organising rules automatically
• A short read-me inside the workbook describing how to trigger or schedule the macro
Acceptance
I’ll consider the task complete when I can drop a fresh data dump into the sheet, press one button (or rely on Worksheet_Change), and see the file instantly match the template I’ll provide.
If this sounds straightforward to you and you have a track record with VBA automation, let’s get it done.