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
Last edited by jwslam; 11-22-2019 at 02:15 PM.
|