Your solution works exactly as to what I need. I actually start at "A33" instead of "A1". I adjusted your code to reflect that. I would ask you to humor an old man and make a slight mod to the procedure. Could you extend the code to have the data in column "B" to overwrite the data in column "A" (starting at row 33)....keeping in mind that the number of rows in column A is greater than the number of rows in col B. In addition, would you make the data right justified in each cell. Presently the data received is a mixture of justification