Selecting an offset record in a filtered Pivot

[IrishDave2137]

Hi guys,

I have a pivot table which I'm filtering on a given value in column A.

I need to be able to create a loop to go through each row in the filtered range, select the value in column C and write that back to another table.

I'm battling to find something similar to an offset for pivot tables which I could use to select the value in column C.

Wondering if anyone has had a similar challenge which they managed to overcome?
I think I can figure out how to loop through each row but open to advice there too

Thanks in advance,

Dave