Do Loop with Variable Range

The following macro is in a file that I inherited and I would like to change it so that it will stop after reaching the last row of data (blank after that). I am new to Macros and it looks like there is a lot of junk in this macro, but right now I just want to limit it to the data range which changes daily when this is run. Any help is appreciated.

Please Login or Register  to view this content.

The last row of data in which sheet in which workbook?

PS Can you use code tags when posting code?

This would loop through column B starting at 2 and stepping 13 rows each iteration.

I've shown how you could use I in the first few lines.

I can't figure out the rest of the code, it's seems to jump about a fair bit, so I'm not sure how it would fit in there.

Please Login or Register  to view this content.