I have a spread sheet that has lots of information. The first 2 columns have the information I want in another worksheet.

When I copy those two columns and associated rows I get all kinds of errors but not the information displayed in that cell.

Is it possible to copy the information displayed to another worksheet?