Suppose I have a worksheet with this data:

Student Grade
Jack A
Jill B
Joe C
Sue B

How do I make a macro to select only students with grade B and put
them in another worksheet that shows:

Student Grade
Jill B
Sue B

(This is of course just a simplified view of my problem).

I've tried to record a macro using autofilter, go to select visible
cells only, copy and paste, etc. but when I examined the code I found
that it contained specific cell ranges and therefore not really usable
outside the immediate workbook...