Hey T, thanks for the videos! In the string "ws.Range("B" & currentRow).PasteSpecial Paste:?xlPasteFormulas" I can't make out the character between the : and the xl. Would you be able to help? Thank you!
Not sure, but here is the section of the loop: For currentRow = formulaRow + skipRows + 1 To lastRow Step skipRows + 1 ws.Range("B" & formulaRow & ":H" & formulaRow).Copy ws.Range("B" & currentRow).PasteSpecial Paste:=xlPasteFormulas Next currentRow