Hi,
I have two different sheet .
first sheet has 4 pivot in pivot sheet ,i need to copy these 4 pivot only row labels to result sheet column b one after the other .Moreover in result sheet column a i am supposed to copy value in range(a1) and fill in till the row labels of pivot1 and then range(d1) and pivot2 after the pivot1 values.please help.
I have two different sheet .
first sheet has 4 pivot in pivot sheet ,i need to copy these 4 pivot only row labels to result sheet column b one after the other .Moreover in result sheet column a i am supposed to copy value in range(a1) and fill in till the row labels of pivot1 and then range(d1) and pivot2 after the pivot1 values.please help.