Thank you macropod this works like a charm, i couldn't have done it without you!

Ok now i have this Macro working for me and doing alotALOT! of my long hand work. Was wondering if there is a way to count the welders for each weld (Done) and couunt if there is a date in a cell in the row from which it counts. so if a welder gets credit for 1 weld inwhich his ID is in a cell in that row. could there be a function or macro that would count if the row has a date in a coulumn. example the welder has 20 welds (Done) if 15 rows have been x-rayed then the number beside 20 welds is 15 for the number of xrayed welds. thanks in advance for any help or communication
if this cant be done or is too complex just let me know but this would be of great benefit as well.