VBA Code (Ifblank then do this)

Copper Contributor

Hello All,

 

I am writing a code to go to the last row of column L in a dataset. If the cell is blank then I want to it go up one cell and over to the right 3 cells, copy and paste the data from cells n:p then paste that data in the n:p cells above the cells that were just copied (for example; start at L74, then go up to L73, if L73 is blank then go over to N73:P73 and copy that data, then go up and paste that data into N72:P72, and then clear the data from 73. After words i want it to go N72, which is not blank so a formula to say if not blank then proceed to N71 and search if blank and repeat the same steps). The data will not always start at the same location so a fluid code is needed. 

 

Thank you,

0 Replies