Worksheets and Workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 worksheet 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 worksheet without
having it linked so that I can copy this worksheet to another location and
not get errors in the cells?


Thanks for your time!!
 
Hi Tia,

If you are copying it another Excel workbook you could select Edit -> Paste
Special and then Values. Otherwise you could copy your combined sheet to
another sheet and paste values and then copy from that.

Michael
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Highlighting duplicates 0
combine worksheets 1
Combine 3 of 6 worksheets 1
Create formula that combines numbers from multiple workBOOKS? 1
Collate Worksheets into single workbook 3
Combine Several Worksheets within a Workbook 1
Merge data from different worksheets 3

Back
Top