View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John John is offline
external usenet poster
 
Posts: 2,069
Default Copying Workbooks and keeping the formulas only?

I have a workbook that contains almost 50 worksheets that has all the sales,
quota, regions, etc for this year. I need to use this workbook for Sept 08 -
Sept 09, but do not want all of the numbers that have been entered. I only
need the formulas for all of the calculations and I will enter the other
information (Like Quotas, etc) that needs to be entered.

How do I do this? It only allows me copy all of the worksheets into another
workbook, but copies everything. I just need the formatting and the
formulas...

Thanks in advance.