Design question: aggregate data from multiple users with output reporting

JackDanIce

Well-known Member
Joined
Feb 3, 2010
Messages
9,334
Hi,

Working on a project to aggregate monthly reporting revenues for a company using Excel.

Outline:

User inputs data and revenue for 1 team
(4 additional teams need to be able to do this)
An aggregate output needs to show all user inputs across all teams
Before month-end, user can change/rebook revenue for their own team
Once month-end is locked down, revenues can't be changed (need a tracker for pre month-end change)


Initial thoughts

Design a data capture form/template
Write input to a centralised location - which generates aggregate output (probably via pivot table)
Use some kind of match to be able to retrieve inputs for edit/change
Something to determine lock-down to prevent edits
Different users to have different levels of access/edit change etc

Have some thoughts like using a CSV file as a temporary cache to allow data read/writes, with pivot table connected to it.

Whilst this would be so much easier on a database, powers that be would like it in Excel.

Rather than try to reinvent the wheel, I thought I'd ask for feedback here from anyone who's done a similar exercise.

TIA,
Jack
 

Forum statistics

Threads
1,082,585
Messages
5,366,466
Members
400,892
Latest member
lamarh755

Some videos you may like

This Week's Hot Topics

Top