Copy Values in a cell (derived from formulas)

G

Guest

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.
 
G

Guest

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
 
P

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
 

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

Top