Hi Bobby,

Try the attached update. The main issues were that the code was:
• starting from row 3 on the 'Welder Totals' sheet instead of row 2; and
• testing column B on each worksheet to get the count of used rows. On some sheets, that column was either empty or incomplete. It now tests column A.

Attached Files

Weld ProgressionPOSTONLINE2.xlsm (307.2 KB, 17 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]