Moderatori: Anthony47, Flash30005
With Worksheets("Foglio1").PivotTables(1)
For x = 1 To Worksheets("Foglio1").PivotTables(3).PivotFields(1).PivotItems.Count
CurItem = .PivotFields(I).PivotItems(x).Value
' Cells(x + 20, 1) = CurItem '<< Test only
' codice selezione pagina
Next
End With
ActiveSheet.PivotTables("Tabella_pivot1").PivotFields("Matricola").CurrentPage = CurItem
myVArr = Worksheets("Foglio1").PivotTables(1).DataBodyRange
myVArr = Worksheets("Riassunto operatore").PivotTables("Tabella_Pivot1").TableRange1
Sheets("riepilogo automatico").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Resize(UBound(myVArr, 1), UBound(myVArr, 2)).Value = myVArr
Sub automatismi()
Dim x As Integer
Application.ScreenUpdating = False
Worksheets("Calcolo").Select
ActiveSheet.Unprotect "Elisabetta"
Worksheets("Riassunto operatore").Select
ActiveSheet.Unprotect "Elisabetta"
Worksheets("riepilogo automatico").Select
ActiveSheet.Unprotect "Elisabetta"
Rows("1:1").Select
Selection.AutoFilter
Worksheets("Calcolo").Select
ActiveSheet.Unprotect "Elisabetta"
With Worksheets("Calcolo").PivotTables("Tabella_Pivot1")
For x = 1 To Worksheets("Calcolo").PivotTables("Tabella_Pivot1").PivotFields("Matricola").PivotItems.Count
CurItem = .PivotFields("Matricola").PivotItems(x).Value
Worksheets("Calcolo").Range("C3") = CurItem
ActiveSheet.PivotTables("Tabella_pivot1").PivotFields("Matricola").CurrentPage = CurItem
Worksheets("Riassunto operatore").Select
Worksheets("Riassunto operatore").PivotTables("Tabella_Pivot1").PivotCache.Refresh
'ActiveSheet.PivotTables("Tabella_pivot1").PivotSelect "", xlDataAndLabel, True
'Selection.Copy
'Worksheets("riepilogo automatico").Select
'If ActiveSheet.Range("A2") = Empty Then
'ActiveSheet.Range("A1").Select
'Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
' :=False, Transpose:=False
'Worksheets("Calcolo").Select
' Else
'ActiveSheet.Range("A1").End(xlDown).Offset(1, 0).Select
'Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
' :=False, Transpose:=False
' Worksheets("Calcolo").Select
' End If
'Next
myVArr = Worksheets("Riassunto operatore").PivotTables("Tabella_Pivot1").TableRange1
Sheets("riepilogo automatico").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Resize(UBound(myVArr, 1), UBound(myVArr, 2)).Value = myVArr
End With
Worksheets("riepilogo automatico").Select
Rows("1:1").Select
Selection.AutoFilter
ActiveSheet.Protect "Elisabetta", DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowFiltering:=True
Worksheets("Riassunto operatore").Select
ActiveSheet.Protect "Elisabetta", DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowUsingPivotTables:=True
Worksheets("Calcolo").Select
ActiveSheet.Range("C3").ClearContents
ActiveSheet.Protect "Elisabetta", DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowUsingPivotTables:=True
Application.ScreenUpdating = True
Worksheets("riepilogo automatico").Select
End Sub
Worksheets("Foglio1").PivotTables(1).DataBodyRange.Select
Torna a Applicazioni Office Windows
Macro modifica date scelta periodo Autore: Ricky0185 |
Forum: Applicazioni Office Windows Risposte: 11 |
Supporto per sviluppo macro VBA Ordinare per data Autore: Carletto Ribolla |
Forum: Applicazioni Office Windows Risposte: 3 |
adattare il contenuto alla pagina Autore: trittico69 |
Forum: Applicazioni Office Windows Risposte: 12 |
Visitano il forum: Nessuno e 21 ospiti