| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy text from one worksheet to another | Excel Discussion (Misc queries) | |||
| I need to copy a text value from one worksheet to another | Excel Discussion (Misc queries) | |||
| Copy text from text box to cell in another worksheet | Excel Worksheet Functions | |||
| Can I copy everything EXCEPT text from one worksheet to another sh | Excel Worksheet Functions | |||
| How can I copy text from one worksheet to another | Excel Worksheet Functions | |||
Threaded Mode
