It shouldn't have ran from Z. It ran on the proper columns in the workbook you attached.

The rows below AL37 aren't cleared because the value for it doesn't appear anywhere else. I thought that was the stipulation you wanted?