Hello,
I'm trying to get my 'total ordered to date' to change when I filter by month. My 'total problem' changes if I filter by August for example but the 'total ordered to date' doesn't.
I would imagine it's because the 'totals ordered to date' are on a different worksheet but can anyone advise how I would link this so when I filter by month that both totals change?
File attached
Thanks
Innes
Bookmarks