View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richard O. Neville
 
Posts: n/a
Default I would like to copy & "paste special" an entire book

Not sure I understand--you want to copy the results summary without the
formulas? You could make a copy of the summary (within your workbook), then
select the whole sheet, copy, then paste; when the drop-down menu appears,
select "values and number formatting." This will change all the formulas and
references to absolute numbers. You could then copy the whole thing
somewhere else, if that is your intention.

"rb" wrote in message
...
I entered data with a variety of formulas for a period of 12 months (each
month on a seprate sheet).
How do I copy the entire book without the contents?