Ok Gurus, Iím crying uncle. Iíve been trying to figure this out and am still stuck.
I have a simple sheet that paste data into. Then I use a button to look at columns A & B to see if there are any blank cells. Then if there is a blank cell it will look to the cell directly above it and copy the data into it. This works perfectly. However if there are no blank cells, how can I write to code to ignore the instructions and move forward? Iíve tried ďOn error resume nextĒ but I think my placement is off, perhaps the way I have the code now is not structured properly. I would greatly appreciate any guidance. This forum has always been such a fantastic resource and I am so grateful for the kindness I find here. Thank you!
Iíve uploaded a sample sheet, with two tabs. One has data with blanks and one without. Thank you again for taking a look!