•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Identify Missed Amounts From PivotTable to Payment Table
I am unable to share the original file which shows the data source. I hope you can help me based on what you see within the worksheet though.
In the spreadsheet, the Payment Table, Amount column is referencing the PivotTable based on the Function and the AOBJ within the PivotTable. The value from the PivotTable is then showing in the Amount column.
I am open to suggestions, but I am needing a way to identify the lines that are showing on the PivotTable but are not showing on the Payment Table so that I can add those lines.
https://docs.google.com/spreadsheets/d/1OXc43YGwYe0sHSCyUPgDGfaJqiEHMp-c8ofifkyg9TM/edit?usp=sharing
[link] [comments]
Want to read more?
Check out the full article on the original site