I want to copy only the layout and formulas and not the exisiting
 

I want to copy an exisiting worksheet with all the formulas and layout but
don't want to take all the data contained within the sheet so that I can
resuse the existing layout? Any ideas?

Depending on your actual sheet layout, this might be workable ...

After you copy over the entire sheet, you can press F5 Special Constants
OK to select the data*. Then clear with the Delete key
*includes col/row labels etc, if any, unfortunately

And then re-copy paste over the col labels as required (< this is the part
which might prove a bit tedious to do)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"edv" wrote in message
...
I want to copy an exisiting worksheet with all the formulas and layout but
don't want to take all the data contained within the sheet so that I can
resuse the existing layout? Any ideas?