Peter Jon White wrote:
I've got a spreadsheet with product descriptions and prices. The
prices are derived from calculations on a different worksheet and
linked from that other worksheet. I need to do this so that I can
easily change prices as the dollar exchange rate changes, or shipping
costs change, etc. I'd like to make my changes in one file, and have
the price list update automatically. Then I'd like to be able to send
out the price list only, without the supporting calculations. But I
can't figure out how to copy and paste the worksheet into another file
and maintain the values in the price cells. Without the other
worksheets in the file, the data goes away.
How do I copy the spreadsheet to another file so that I just get the
calculated content of the cells?
Thanks!
You've received some other suggestions, but the first one that came into
my mind is that you Copy the range that contains the prices that you're
interested in, open a new, blank, worksheet, and then do a Paste Special
-- In the Paste Special dialog box, under Selection, check everything
except for Formulas. That will paste the actual numbers in. (ie the
calculated contents of the cells, which is what you're after)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
