References

QuestionEdit

I have created a workbook that works fine. 1 of the sheets references cells on other sheets and it makes a nice output. What I want to do is to copy that output to another workbook without carrying over the references, is this possible?

AnswerEdit

You don't say what version ofyou're using, so I'll guess it's2007.

Open your workbook and a new workbook. On your workbook, select the range you want to copy. From the Home ribbon, click on on Copy. On the new blank workbook, select the upper-left cell to paste to, then from Home ribbon click on Paste/Paste-Special/Values, Paste/Paste-Special/Formats, Paste/Paste-Special/Column-Widths.