Can I ask for a sample code for my problem. I want to copy data in the cell if the following cell is empty.
Sample
Column A Column B Column C Orange Red ABC:Red
Now when I run the code that im asking this what the output should look like
Column A Column B Column C Red ABC:Red Orange
Since Orange is in Cell A and Cell B is empty then Cell A data is moved to Cell C and then those under them will be pushed upward as if the user has deleted a cell to move the data upwards,
Hope you get my point.
Bookmarks