Hello,
I got the following code by recording a macro which fills a cell in a table, using a cell located in another worksheet, within a pivot table.
"=GETPIVOTDATA(""No of Tickets"",'[First Level Resolution.csv]IPVPN 1st Level'!R12C3)"
I need to convert the R12C3 to a dynamic cell and have located that cell dynamically and set it as x.
Any ideas as to how I can change the formula to use x instead of R12C3? Have tried different options with no luck.
Any help is appreciated. Thanks.
Bookmarks