Copy Values in a cell (derived from formulas)

[Ali]

I have a document.
This consists of say 12 worksheets. The last worksheet has a table. The
values in this table are derived from formulas/references to the other 11
sheets.
I know that if I wanted to copy values from sheet 12 to a NEW document, it
is easy. Just copy, paste special, values etc.
To get more tricky. However, lets say i need to email this document to a
friend, but I want to delete sheets 1-11 before he gets it. IS it possible
to ensure that cell VALUES are shown on sheet 12, before I delete
corresponding sheets 1-11.
I often want to forward sheets to people, and save it as a different name
before adjusting, but then dont want to go to all the hassle of copying and
pasting.

 

[CLR]

You can Copy > PasteSpecial > Values, in Place also, just be sure not to save
that file back over the same name or you will lose the formulas...........

BTW, almost anything that you have to do frequently can be set to run with
Macros..


Vaya con Dios,
Chuck, CABGx3

 

[Pete]

In a case like this I would suggest you copy the summary worksheet into
the same file (with CTRL-drag), then fix the values on this copy of the
sheet, then drag the sheet off the workbook window into the grey area
of the Excel window (you will have to make the workbook window smaller
than the Excel window) then use File | Save As on this new workbook to
give it a different name. Your original workbook is unchanged, though
you will still have to save it as you have made changes to it.

Hope this helps.

Pete