1 Need to create a report showing how many participants per region, per state and how much money calculated per region and per state
2 Course 1, Course 2, Course 3 will be in separate sheets but will be updated everyday as new partcipants join
3 I am thinking it can be created using Pivot table. Also, is there a way to copy this data in Google docs and keep the data updated
4 How can I make this report available to people who do not use Pivot charts or have any idea about data manipulation.
5 How do I populate the master list with dynamic data from Course 1, Course 2 and Course 3
I have attached a sample file.
Thanks.
Here's a PivotTable based on your sample data, you need to read up on Pivottables
http://www.excel-it.com/pivot_tables.htm
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
How will I increase the counts for the participants every time I update the course lists ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks