This video demonstrates how to create a recorded macro that will work on different sized data regions. Using relative references and short cut keys to move to the edge of a data region or select a data region we can create a macro that works whatever the size of your data.

Also features a do while loop that will run the code until the active cell is empty so you don't have to run the code on each set of data - it will run automatically until no more data is found.
------------------------