The pivot table solution creates the sheets ie the sheets with the name of the code which is fine what it doesn’t do is use the template worksheet as ...
Apologies File attached now
Thanks. the 2nd mock up is because I was given more information - frustrating I know. The pivot table option doesn't work for me as all I can do i...
Thanks Mynda That works but not quite as I do need to keep the x y z separate per department I've tried the following =SUMPRODUCT(--(Sheet1!A...
Hi Mynda Thanks I've looked at that but I don't think that will work in my scenario as the spreadsheet (i have no control over the design) has bla...
Thanks - that was enough info to get it working It was supposed to say nest - this i've done now but is it possible to have both axis labels horizo...
Works perfect - thank you