Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste into new workbooks
Please help me?
I am working in excel 2003. I have a working pivot table with over 50 entries. I need this marco to run each entry in the pivot table to produce the data and then copy and paste the 2 worksheets into a new workbook for each entry in the pivot table. I need to paste two worksheets into new workbooks so clients can not make changes. So far I am able to create one workbook just like I want but after that it stops. I know I am missing something (I am learning vba by myself ) but I am not sure what. Can someone please help me? Sheets("Pivot").Select For Each itm In ActiveSheet.PivotTables("PivotTable3").PivotFields ("Lessee").PivotItems Next Cells.Select Selection.Copy Workbooks.Add Cells.Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Selection.PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False Windows("Test Template (Revised).xls").Activate Sheets("PD").Select Cells.Select Application.CutCopyMode = False Selection.Copy Windows("Book1").Activate Sheets("Sheet2").Select Cells.Select ActiveSheet.Paste Sheets("Sheet1").Select Sheets("Sheet1").Name = "Form1" Sheets("Sheet2").Select Sheets("Sheet2").Name = "Form2" Sheets("Sheet3").Select Application.CutCopyMode = False ActiveWindow.SelectedSheets.Delete Sheets("Form1").Select Range("B1").Select Selection.Copy Sheets("Form2").Select Range("F6:H6").Select ActiveSheet.Paste Application.CutCopyMode = False ActiveCell.FormulaR1C1 = "(All)" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Copy and paste between workbooks | Excel Discussion (Misc queries) | |||
Copy and paste between workbooks? | Excel Programming | |||
Copy and paste - two workbooks | Excel Programming | |||
Copy and Paste Between Workbooks | Excel Programming |