Jun 18 2019 07:40 AM
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,