I have a macro I am working on. I have found a way do the find, cut and paste, but it does not loop, It stops after the first find, cut and paste.
When there are blanks in K there will be data data sitting in L that needs to be moved to P. See the attachment please.
Below is the code I used to find a blank K to then cut L to paste in P, but it only works for the first line. I need it to loop through a variable length sheet. A column that will be full of data until the end of the sheet if needed to reference an end is column C.