1 min readfrom 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

submitted by /u/GlideAndGiggle
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article