I am trying to copy and paste selected rows from varios workbooks into one
master workbook. When I copy and paste a range of cells I find the rows
collapse and show only one line of text. How can I copy and paste this
information and automatically show all text in that cell? Some rows have one
or two lines of text, others have up to 12 to 14 lines of text.