| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
REMOVING WORKBOOK'S ALL FORMULAS
I have a workbook consisting around 20 sheets. I want to copy all the same to
a new workbook with only values. Any shortcut how to remove all the formulas instead of copypaste specialvaluesok on every sheet? -- Best Regards, FARAZ A. QURESHI |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
REMOVING WORKBOOK'S ALL FORMULAS
In the new workbook, do you want the formulas replaced by blanks or by the
values from the old workbook? -- Gary''s Student - gsnu200811 "FARAZ QURESHI" wrote: I have a workbook consisting around 20 sheets. I want to copy all the same to a new workbook with only values. Any shortcut how to remove all the formulas instead of copypaste specialvaluesok on every sheet? -- Best Regards, FARAZ A. QURESHI |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
REMOVING WORKBOOK'S ALL FORMULAS
It was stated I want values!
-- Best Regards, FARAZ A. QURESHI "Gary''s Student" wrote: In the new workbook, do you want the formulas replaced by blanks or by the values from the old workbook? -- Gary''s Student - gsnu200811 "FARAZ QURESHI" wrote: I have a workbook consisting around 20 sheets. I want to copy all the same to a new workbook with only "values". Any shortcut how to remove all the formulas instead of copypaste specialvaluesok on every sheet? -- Best Regards, FARAZ A. QURESHI |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
REMOVING WORKBOOK'S ALL FORMULAS
Forgive a Student's lack of attention. Perhaps this macro can be adapted to
meet your needs: Sub Macro1() Application.CutCopyMode = False ActiveWorkbook.SaveAs Filename:="C:\Documents and Settings\Owner\My Documents\copy.xls" For Each sh In Sheets sh.Activate Cells.Select Selection.Copy Range("A1").Select Selection.PasteSpecial Paste:=xlPasteValues Next ActiveWorkbook.Save End Sub -- Gary''s Student - gsnu200811 "FARAZ QURESHI" wrote: It was stated I want values! -- Best Regards, FARAZ A. QURESHI "Gary''s Student" wrote: In the new workbook, do you want the formulas replaced by blanks or by the values from the old workbook? -- Gary''s Student - gsnu200811 "FARAZ QURESHI" wrote: I have a workbook consisting around 20 sheets. I want to copy all the same to a new workbook with only "values". Any shortcut how to remove all the formulas instead of copypaste specialvaluesok on every sheet? -- Best Regards, FARAZ A. QURESHI |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing data entries but not formulas or formats | Excel Worksheet Functions | |||
| vlookup - removing formulas | Excel Discussion (Misc queries) | |||
| How do I go about finding and removing labels in formulas? | Excel Discussion (Misc queries) | |||
| Removing labels and names in formulas | Excel Discussion (Misc queries) | |||
| Pasting data without removing formulas | Excel Discussion (Misc queries) | |||
Linear Mode
