Worksheets and Workbooks

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have a workbooks that has 3 worksheets.

I have taken the 3 worksheets and combined them into 1 (combined) worksheet
using formulas. They are all located in the same workbook. I now want to
export data from the combined work*** so I need to seperate it from the
other 3. However, if I copy it the data is replaced with error messages
since I used a formula to obtain it from the other worksheets. Is there a
way to keep the information as it appears on the combined work*** without
having it linked so that I can copy this work*** to another location and
not get errors in the cells?


Thanks for your time!!
.

Quantcast