References

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:52 PM GMT

Question

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?

Answer

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.

Advertisement

©2021 eLuminary LLC. All rights reserved.