Forum Discussion
Moving Rows Based on Information in a Cell
I'm not the "big pro" when it comes to pivot
(to put it mildly, my knowledge is modest, very modest :).
But I see in your plan that this can be the best way.
I will also work out a VBA macro, but first I would like to ask if this is what you want to express in the end the result?
I would appreciate your feedback.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
NikolinoDE I was going to mention pivot table option but I am also no expert on them and find them annoying to set all the properties to get them to look the way I want and because in my experiences I have had issues with them. That said, I did take your lead and include in the attached, pivot tables on sheets 1 and 2 that basically replicate the table that Brittany0724 has on each of those pages. (Note: I have Card Number listed first but that can be changed back to column 2)
On sheet 1 I used the drop down menu to manually filter but the items desired and on sheet 2 I added a slicer to do the filtering.
NikolinoDE If you are going to continue with a Macro solution, you will still need to have some input/strategy for identifying what card numbers need to filter by and a way to 'run' the macro. As a "cute" alternative you could write a macro that pastes the FILTER() formula I used above and then copy and paste values instead of actually writing the code to perform the individual selections.