I have a report that has thousands of lines and each part # on that line has a specific stocking location. Now there are certain locations that I want to see and certain ones that I want to filter out. Is there a macro that I can set up so I set up a button and it filters out from the list? So if a had seperate lines that had locations a, b, c, d, e, f, g, h and I had another file that had locations g and h on it, it would filter out those. But this would be thosuands of lines so I need a way to look at that entire list