Here is a screenshot, can't really attach the workbook, my company won't allow it, but any troubleshooting tips?

the empty space in column C is actually bunch of company information I had to cut out for privacy.

sheet.jpg