software

Have an excel workbook with multiple work sheets, need to copy all formulas,
styles, layouts, etc. to new workbook without the data in the original
workbook?

Do I need to create the work sheets and names prior to copying?

save the workbook with a new name, then clear all constants in all sheets
and you have your copy.

quot;Omnitoolquot; gt; wrote in message
...
gt; Have an excel workbook with multiple work sheets, need to copy all
gt; formulas,
gt; styles, layouts, etc. to new workbook without the data in the original
gt; workbook?
gt;
gt; Do I need to create the work sheets and names prior to copying?
Can I clear the constants collectively in each sheet with out effecting the
formulas or style?

quot;Bob Umlasquot; wrote:

gt; save the workbook with a new name, then clear all constants in all sheets
gt; and you have your copy.
gt;
gt; quot;Omnitoolquot; gt; wrote in message
gt; ...
gt; gt; Have an excel workbook with multiple work sheets, need to copy all
gt; gt; formulas,
gt; gt; styles, layouts, etc. to new workbook without the data in the original
gt; gt; workbook?
gt; gt;
gt; gt; Do I need to create the work sheets and names prior to copying?
gt;
gt;
gt;

Sure,

Edit/Go To/ Special/Constants/OK
Hit delete

Beegequot;Omnitoolquot; gt; wrote in message
...
gt; Can I clear the constants collectively in each sheet with out effecting
gt; the
gt; formulas or style?
gt;
gt; quot;Bob Umlasquot; wrote:
gt;
gt;gt; save the workbook with a new name, then clear all constants in all sheets
gt;gt; and you have your copy.
gt;gt;
gt;gt; quot;Omnitoolquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Have an excel workbook with multiple work sheets, need to copy all
gt;gt; gt; formulas,
gt;gt; gt; styles, layouts, etc. to new workbook without the data in the original
gt;gt; gt; workbook?
gt;gt; gt;
gt;gt; gt; Do I need to create the work sheets and names prior to copying?
gt;gt;
gt;gt;
gt;gt;