Vba: Select Multiple rows based on Text

I have a list made up of 4 columns and undetermined rows. I am trying to collect only Col B and C where Col B has words Jackpot and copy them in order to a new sheet. I have gotten the list to sort, but using UsedRange, copies all the rows. How do I only copy over B and C?I have a list made up of 4 columns and undeterm