I have a spreadsheet with the following tabs:
Main Sheet : Open : Closed : Cancelled
I have code that when I change the Status Column, it will move between the following tabs based on the status - Open : Closed : Cancelled
This seems to be working fine.
The problem I have is on my Main Sheet. The calculations of movement are not reporting correctly, have a look at items closed for March 2013 as an example.
Is there a simpler way to do these calculations, specially when I have to extend the months and want to hide some earlier months but still want to see the totals being displayed correctly
Hope this makes sense