Are you getting new files or is the data updated in the same file?
I would have 2 pivots with one filtered on A and another on B then have a dynamic named range wrapped around the two pivots.
Are you getting new files or is the data updated in the same file?
I would have 2 pivots with one filtered on A and another on B then have a dynamic named range wrapped around the two pivots.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks