I'm trying to create a macro that can select a field in a pivot table field list and move it to the values area, but indirectly.

Doing this with a hardcoded field name is no problem (the Indirect function will do this) however I'd like the code to select the field dynamically based on a value of a spreadsheet cell.

Does anyone know how this can be done ?