Dear Forum,
let's assume following setting:
I have a workbook consisting of two Sheets. "B" contains a Pivot Table.
"A" contains "GetPivotData" formulas reffering to sheet "B". Here certain criteria of Sheet "B", e.g. Month = 10 and Year = 2009, are checked and if found, the respective PivotData returned.
My question: Is there a possibility, to not return the value, but the respective cell's address in sheet "B"?!
Hope You can help me fix this!
Regards,
Jan
Bookmarks