Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
I am trying to get the individuals units from the sheet and I cant seem to get it working could someone help me out
Your sheet does not work without the external Excel files.
But the routine is failing because you try to look up the values in the second columns of C ("1 in"), too and they can't be found of course.