Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Substitute for Pivot tables?
Hi everyone!
I have a solution to my problem however it involves pivot tables and I am after a substitute to those as others need to use the workbook... The workbook contains sales agents and their stats, updated on a weekly or even daily basis - including the number of "late apps taken" e.g. 11/04/05 Fred 3 days late 18/04/05 John 2 days late 18/04/05 Fred 1 day late I want a summary on another sheet to show: Date 11/04/05 18/04/05 25/04/05 etc. Total Fred 1 1 2 John 0 1 1 The main issue is a) this is updated weekly and b) I would like this to go into ascending order without much ordeal i.e. the user does not mess around with "sort" functions etc. Macros may work however new sales agents may join and it could get a little messy. Any suggestions? Your help would be most appreciated and as one good turn deserves another I will try and help someone else with a problem! Regards Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to pull numbers from two tables with conditions? | Excel Worksheet Functions | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Automation of Path of linked tables | New Users to Excel | |||
Combining Tables | Excel Discussion (Misc queries) | |||
How to paste Xcel tables legibly into Word . Help!! | Excel Discussion (Misc queries) |