cj0467
11-06-2008, 12:44 PM
Hi, I am new to VBA and am having difficulty figuring out how to do the following:
I need to be able to use VBA to search through the C column and find all cells with values which begin with a letter. For each of these, the values need to be moved to the left to the A column and up 1 cell. (Only values that are not letters should remain in the C column). After this has been done, I need all blank rows to be deleted. Does anyone have a solution or something similar I could try to modify to suit my needs?
Any information you can provide will be helpful. Thank you!
I need to be able to use VBA to search through the C column and find all cells with values which begin with a letter. For each of these, the values need to be moved to the left to the A column and up 1 cell. (Only values that are not letters should remain in the C column). After this has been done, I need all blank rows to be deleted. Does anyone have a solution or something similar I could try to modify to suit my needs?
Any information you can provide will be helpful. Thank you!