Reduce block of code

Please Login or Register  to view this content.

I currently have the above code repeated approx 1000 blocks of the damn code, (done by a predecessor). Can I condense it ? The code checks in column IV2 and then use its value to filter the data in the sheet then it use IV to open a document and paste the dat into it, then I have another block of code that does the save for IV3 , IV4 , IV5 IV6, AND So on.

The list held in IV has no duplicates at all.

Any help I tried a few things but I just messed it all up ? the normal script writer has left and im having to pick up the pieces. and my vba knowledge is poor.

It didnt work ? Not true, it worked fine once i removed one the Run "scripts"

Thanks for all the help again, much appreciated

Thanks