cplmckenzie,

I have one more issue that I didn't see until I tried to apply all of your code to my actual document.

I will attach an updated sample worksheet - I have a "percentage of total sales" row beneath my "projected sales" row.

Is there any way to make the code skip every other row?