Macro Looks for Cell Contents & Performs Action
I am trying to create a Macro in Excel that looks at the text in each cell in
column A:
-if the cell begins with " D" (three spaces and a D) then I need to cut
the cell and paste it up one row and right one column, then delete the row
from which it came
-if the cell does not begin with " D", then move down one cell
The loop should end when a cell contains "***"
This seems pretty easy, but I'm new to VBA...
Thanks,
Adam
|