how to copy only values and formats of worksheets to new workbook

R

rvd

Hi zer,
I need to copy worksheets to new workbooks (only values and formats) but
without any cell reference to the original workbook.
 
R

rvd

Sory David, May be i was not so clear. Actually I have serveral worsheets on
a workbook with formulea referencing to one master worksheet on the same
workbook. I want to select several worksheets and copy them to a new workbook
but with values and formats on as my coleagues need not see the formula. I
tried paste special but its a bit time consuming as the all the print
settings and pictures do not come right!

The best thing is just to select multiple sheets and copy to other workbook
by a right click, which keeps everything intact. But the problem is that i
cannot get rid of the fomulea :-(

thanks.
 
S

SteveW

Make a copy of the whole workbook/s
then past copy/value etc etc
sheet by sheet

Steve
 
Top