I am trying to Loop though a list of a data. For every column where L is left blank,
I need to copy column A:K of that row to a second workbook.
I know in need to make the range to be copied and where it should go on the second workbook dynamic.
But I am struggling with getting to work. Below...