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.