Excel VBA Dual-View Spreadsheet

via Freelancer ·

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.
excel excel vba excel macros data visualization
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.