When I copy text (hundreds of rows and several columns) from a worksheet and paste into a table on a different worksheet within the same workbook that is stored locally the paste is not retained and is missing text. Any reason this type of copy and paste (By Values) is not working?