Hello,

I am putting together a (2) sheet workbook for Return Goods Authorization (RMA) and tracking...The first sheet is a summary sheet in which our employee just enters the data. In one of the cells, their may be several serial numbers for our components. So, neatness, upon entering these serial numbers I have them entered in the same cell with line breaks in the cell "Alt" / "Enter"....

I am trying to create a marcro that will copy all of this information on this row to the appropriate cells on the second sheet in which we will print for our records...Everything including the macro work great. The problem is when I am am copying these cells from the first sheet with the line breaks in them (example...5 serial numbers)...It is copying it all back to the second sheet, but only the first line is visable...I have to manually drag the row height to the correct size...

Is there any way that I can format the cell so that when the text is copied from Sheet 1 to Sheet 2 that the cell is autosized and it shows all of the text in the cell?? I have tried the 'autofit' function and it does not seem to do anything...

Thanks in advance..
Mike