djsmarties
Board Regular
- Joined
- Sep 10, 2002
- Messages
- 95
Hi,
another pivot table question.
I have a pivot table that looks like this
Count of record
Days emplyoyee count
1-2 xxx1 1
xxx2 1
3-4 xxx3 1
5-6 xxx4 1
What I need is to copy the list of employees and the count for each specific grouping of days to another spreadsheet.
Is it somehow possible to adapt this code that I am using to copy the total of each row?
With Worksheets("pivot_T").PivotTables(1).DataBodyRange
.Columns(.Columns.Count).Copy Worksheets("pivot_T").Range("H5")
End With
Thanks
another pivot table question.
I have a pivot table that looks like this
Count of record
Days emplyoyee count
1-2 xxx1 1
xxx2 1
3-4 xxx3 1
5-6 xxx4 1
What I need is to copy the list of employees and the count for each specific grouping of days to another spreadsheet.
Is it somehow possible to adapt this code that I am using to copy the total of each row?
With Worksheets("pivot_T").PivotTables(1).DataBodyRange
.Columns(.Columns.Count).Copy Worksheets("pivot_T").Range("H5")
End With
Thanks