Slicemahn
01-03-2008, 04:09 AM
Hi Everyone!
I am looking to copy a set of worksheets from my source workbook to another workbook. It seems easy enough but there's a twist:
The source workbook houses pivot tables and formulas and I do not want either the formulas or pivot tables to be copied over to the new workbook.
How do I copy each worksheet in my workbook and just the values and place it another workbook.
Source Workbook: "Generator.xls"
Sheets: "Sheet1","Sheet2","Sheet3","Sheet4","Sheet5","Sheet6","pivotdata","RAW"
where "pivotdata" and "RAW" will store my pivot tables and SQL tables
New Workbook: "Report.xls"
Sheets:
"Title"
Many thanks for your help on this one.
I am looking to copy a set of worksheets from my source workbook to another workbook. It seems easy enough but there's a twist:
The source workbook houses pivot tables and formulas and I do not want either the formulas or pivot tables to be copied over to the new workbook.
How do I copy each worksheet in my workbook and just the values and place it another workbook.
Source Workbook: "Generator.xls"
Sheets: "Sheet1","Sheet2","Sheet3","Sheet4","Sheet5","Sheet6","pivotdata","RAW"
where "pivotdata" and "RAW" will store my pivot tables and SQL tables
New Workbook: "Report.xls"
Sheets:
"Title"
Many thanks for your help on this one.