Excel VBA Dual-View Spreadsheet
Budget / Salary£250–750
TypeFreelance project
LocationRemote
Posted20 minutes ago
I need a single Excel workbook, driven by VBA, that offers two distinct experiences:
1. A staff working view dedicated to data entry. Here the team must be able to
• enter and update daily records,
• track tasks and their progress, and
• manage basic customer or project information.
This sheet should feel intuitive—clear input fields, dropdown validation where helpful, and buttons or a simple shortcut that posts the entry to the underlying tables without exposing formulas.
2. A summary / report view. This second view should automatically aggregate everything that is entered and present it as:
• headline totals and other key numbers,
• visual flags for task progress and any overdue items, and
• a quick-scan status section for each customer or project.
, conditional formatting and traffic-light indicators are welcome so long as they stay lightweight and refresh quickly.
The two views can sit on separate worksheets or be toggled with a macro-driven interface—whichever keeps the workbook lean and user-proof. All calculation logic needs to stay hidden or protected, and the file must perform well with a few thousand rows of data.
Deliverable: a .xlsm file with clearly commented VBA code, ready for me to drop in sample data and start using immediately.
1. A staff working view dedicated to data entry. Here the team must be able to
• enter and update daily records,
• track tasks and their progress, and
• manage basic customer or project information.
This sheet should feel intuitive—clear input fields, dropdown validation where helpful, and buttons or a simple shortcut that posts the entry to the underlying tables without exposing formulas.
2. A summary / report view. This second view should automatically aggregate everything that is entered and present it as:
• headline totals and other key numbers,
• visual flags for task progress and any overdue items, and
• a quick-scan status section for each customer or project.
, conditional formatting and traffic-light indicators are welcome so long as they stay lightweight and refresh quickly.
The two views can sit on separate worksheets or be toggled with a macro-driven interface—whichever keeps the workbook lean and user-proof. All calculation logic needs to stay hidden or protected, and the file must perform well with a few thousand rows of data.
Deliverable: a .xlsm file with clearly commented VBA code, ready for me to drop in sample data and start using immediately.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.