View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Creating a duplicate workbook without values

Select the region that you want to copy, go to the new book, right-click then
paste-special...look at the options there. Which one suits you? Formulas?
Try that and see how you get along.


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"JTG" wrote:

I created an inventory management workbook for 2009. I'd like to make one
for 2010, complete with all headers and formulas but with the data fields
blank. Can I copy the workbook without cell values, or do I have to start
all over and create it from scratch?