Not sure if possible..brackets issue

[Immatoity]

ok have had a chance to review this now... it's nearly there but still one small issue..

Using Glass example C.xls - row 7 - the result in column T is 33.33%_66.67% ( which is correct). However I only need the % for the item in column L..which in this case is H003804 = 66.67%, i don't want/need the 33.33% (which relates to U24842 in cell J7)

I hope this makes sense.. not sure if its possible or not?

EDIT : being thick here.. I have clicked Alt+F11, copied the code above, saved and closed VBA.

When I click tools macros run "Sheet4.CalcColJ" nothing happens? Also no "sub" Para seems to appear?