Noob questions. I dont know how to use the =getpivotdata formula or perhaps there is a better formula, I would like to use it to extract grand total data for a specific transit in column A and paste it in the approriate places in "invoiced vs recovered" worksheet
here the sample workbook
SAMPLE.xlsb
Bookmarks