1. i created one PivotTable, in the RowAxis, i need the list to collapse.
how to do that in VBA?

2. For that particular RowAxis, I have 100 members.
eg.
Client Name
A1
A2
A3
.
.
.

how ever, i only want to include certain clients. I know the standard code is
.FieldSets("client name").Fields(0).IncludedMembers = Array("A1", "A2")

but, i need to pass in the list of names from another table.
so, for example, i have another recordset with the client names,
A2,
A3,
A5...
I need to pass each of these to be included in my RowAxis.
how to do that?