Hi all,

Having some trouble with a cost benefit excel, any help would be much appreciated.

I'm trying to pull the total vale add time and non value add time expended by each role across from the 'Time Cost' Worksheet into the 'Role Efficiency' Worksheet. I want to populate columns 6 "Total Activity Time (Hrs)" and 7 "Total Waste Time (Hrs)" respectively for each role.

In the 'Role Efficiency' Worksheet I already have a routine set up to take the role info, scale info, FTE info and Available Time (Hrs) from the 'Background' Worksheet.

I have tried a few different things but keep getting tied up in knots! I have attached the excel so if anyone wants to take a shot at ammending it any help is much appreciated!

NB. The tables are not currently showing on the 'Role Efficiency Worksheet' you need to enter a new role through the Workwise menu for it to run.