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
If you want me to automate your whole process with python ill do it for free.
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
Think you meant the "=" but if not the full thing is in comment above
Perfect! Thank you!