Quote:
Originally Posted by jwslam
Is there a reason why it's all on different sheets? Probably easier to put it all together and pivot table it. Less chance for error that way too.
edit: If you don't know what a pivot table is or how it works, the tutorial built into excel is super useful. You can find it in "File, New" in Office365
|
I haven't messed around with pivot tables but it may be of use if I can dumb it down enough for other team members. We have the different sheets to track activities by the month and doing month by month plus yearly analysis which could probably be accomplished by a pivot table as well