View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
buddyorliz buddyorliz is offline
external usenet poster
 
Posts: 6
Default copy a worksheet - but not the value (text)

I have a worksheet that has all the formulas and formating I need, I close it
out and start a new worksheet the end of the month.

What I want to do is make a copy of that worksheet WITHOUT copying the data,
Just the format and formulas.

(Don't want the names and addresses, or the amounts etc...)
I insert a work sheet, I copy the old one then when I go to paste, but the
options I want - Paste all EXCEPT value are not available.
Using the other choices Paste all the data.

When I click on just formulas - I still get all the data,