OK, please interrupt me where I can improve on processes.
As part of my macro, I need to select ten items in my table of data to import into another worksheet.

Is there a way to select more than two if I edit the macro code itself? I tried but it didn't seem to work, by extending the line to include further Criterion:

Selection.AutoFilter Field:=2, Criteria1:="=Fuel Sales", Operator:=xlOr, Criteria2:="=C-Store Sales"