I would like to copy & "paste special" an entire book

R

rb

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?
 
R

Richard O. Neville

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

rb

Thanks for responding
The question is very simple: How do i copy the formula & formats from an
entire book (multiple sheets) without copying the contents?
 
Top