Dear all

i do not have to many knoweldeges for vb.
what i am looking for is that: I have a workbook with many sheets where i
fill on specific sheet with to many formulas (Sheet 1).
There is any way to have a macro where to copy this sheet exactly as it is,
into a new workbook, but without the formulas? (copy paste values and
formats).

Thanks in advance
Manos