Excel VBA Dual-View Spreadsheet

£250-750 GBP

£250-750 GBP

Paid on delivery

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.

Project ID: 40823797

About the project

11 proposals

Open for bidding

Remote project

Active

Place your bid

Bid amount Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

It's free to sign up and bid on jobs

11 freelancers are bidding on average £297 GBP for this job

User Avatar
Flag of PAKISTAN

Hi there, To give your team a simple place to work and a reliable view of what needs attention, I can build a single VBA-driven workbook with a guided entry sheet and a separate, fast-refreshing report sheet. Staff will be able to add and update daily records, tasks, and customer or project details through validated fields. Each saved record will have an ID, so edits update the right row rather than creating duplicates. The report will show key totals, task progress, overdue flags, and a quick status for each customer or project. I’ll keep the underlying tables and calculations protected, use Excel Tables so the workbook grows cleanly with your data, and avoid heavy formulas that slow down a few thousand rows. The delivered .xlsm will include clearly commented VBA and be ready for your sample data. Could you share the fields you want to capture and the rules you use to mark a task overdue? I can use those to make the first version fit your workflow.

User Avatar
Flag of INDIA

⚠️ If you're not happy, you don’t pay. ⚠️ Hi Client, thank you for checking my proposal and sharing the detailed project brief. I can build your Excel workbook using VBA with an intuitive and user-friendly design. I will deliver: • A staff working view for seamless data entry and task tracking • Dropdown validation for enhancing input accuracy • A robust summary/report view with aggregated totals and key metrics • Dynamic visual flags for task progress with conditional formatting • A macro-driven interface for easy navigation between views • Hidden calculation logic to protect your data integrity • Clearly commented VBA code for easy future modifications You will also receive comprehensive documentation for smooth onboarding. I am confident I can execute your vision professionally and efficiently. Looking forward to discussing timeline and next steps. Best regards, Chirag.

内容来自 Freelancer News,版权归原作者所有。

阅读原文 ↗

把喜欢的内容,留在你的新标签页。

打开我的订阅