macro to move contents in a cell and add to another cell
 

Need to clear column of text in large array. Where cell is blank, go to next
cell (down). where cell contains text, go to next column (right) and append
to contains of column two cell continue this loop until end of range. I am
brand new at VBA. Can anyone help?

macro to move contents in a cell and add to another cell
 

Bob, your description of the requirement is not very clear. Can you post an
example of the data base? Append what to what? Do you mean "Column to cell?
Need clarification.

"Bob H" wrote:

Need to clear column of text in large array. Where cell is blank, go to next
cell (down). where cell contains text, go to next column (right) and append
to contains of column two cell continue this loop until end of range. I am
brand new at VBA. Can anyone help?