I'm sure there must be an easier way of doing this, but my knowledge is limited, so I thought I'd throw it up for you guys.
Raw data is captured every month, for all incidents and requests between 8 sites. Currently, I'm using a sheet for each month.
I need to report the incidents and requests across these 8 sites individually, showing a monthly summary of ticket statuses (see summary sheets).
I'm currently using SUMPRODUCT to populate an individual sheet for each site, but the entire spreadsheet is taking ages to update and has become unbearable.
Please could someone tell me if there's an easier way?
(I'm also using INDIRECT to help save changing the formulas for each month)
Many thanks in advanced for anyone mad enough to look at this,
Dave.
Bookmarks