Trying to build a formula in a table to cross reference multiple data fields (Work out Loading of resources across multiple projects by month)
This one is probably a lot simpler than I think, and I'm guessing I've massively over complicated everything.
Basically I have a workbook of tables of data. The tables record details of staff, their monthly working hours, current projects, what staff are assigned to those and how many hours they have a month on each project, what percentage of their total availability that is etc
Tables: Projects: This is where I list all the projects, and who is assigned, and how many hours
Tables: Resource: This is the list of staff, and a divider to get their weekly hours (From 40 max, so set to 2 would mean their weekly hours are 20)
Tables: WorkHours: This calculates using network days how many working hours there are in a given month, and reduces that by bankholidays etc
Tables: MonthsActive: This calculates what months each project is live for
Tables: ResourceLoading: Should calculate total hours Loading for each member of staff for each month
Resource loading is where my issue is. I'm stuck trying to build any kind of formula to do this. Last resort, I'll go VBA, but if this is possible to do in the worksheet with Formulae, I'd rather go that route.