I'm using quite a large dataset which I need to analyse in some detail at various summary levels. I've been using a technique I picked up on here, (thank you), but I'm now finding the workbook is becoming too large and unwieldy.
This is almost certainly because I'm using lots of charts to provide some insight into the data. I need to keep the charts.
I'm now considering filtering the data by a chosen summary level and copying it into a template where my calculations and charts already exist. I've had some trouble with this in the past, I get confused with thisworkbook command. Can anyone point to a website that explains how to use this properly or give me some pointers.