Hi there, welcome to the board!
I'd take a look at using Advanced Filter. If you want to to do this on a button, record your macro first, then assign it to a button. We can always help you clean it up if you post it. Remember with Advanced Filter you can copy to another sheet, but you want to start from the destination sheet when you start the process.![]()
Bookmarks