Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data summary
I trying to sort out a small spreadsheet for a charities collections and want
to keep as simple as possible as the users are novices. They are using Excel 2000. I set up a sheet that worked, but of necessity contained 26 columns ( one for each collectors takings) spread over 200 rows (Theoretically 366 max). In practical terms it wasn't user friendly. In essence it would be better to need only to enter a date, a name and a sum of money in 3 columns and have totals calculated in secondary sheets. My guess is that in order to get meaningful monthly totals against each of the 26 collectors will require some VBA code to pull that data into separate sheet. Can anyone guide me on data manipulation. I need to identify all instances of each of the names and total each name's takings for each calender month. thanks Pete |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summary data | Excel Discussion (Misc queries) | |||
Use detailed data in one worksheet to create summary data as chart source | Charts and Charting in Excel | |||
multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
Summary of Data from a Range | Excel Discussion (Misc queries) |