Macro to Filter, Select, Copy, Paste (Baseball Related)

Hi, this seems like the easiest thing in the world, but I cannot make it work so any help would be appreciated. I spent the past few hours searching and trying to answer my own question but that didn't work out so well.

Here's the question:

Workbook "Fantasy Baseball" contains 3 Worksheets "Roster", "Hitters", "Pitchers"

Worksheet Roster has 25 rows, each with the following columns:
COL A = Players Designation ("H" for Hitter or "P" for Pitcher)
COL B = Players Name
COL C = Players Position
COL D = Players Ranking
COL E = Players Salary
COL F = Hyperlink to Player Notes on MLB.com

I'm trying to create a macro that will look at COL A and when it finds an "H" it copies only COL B (Player Name) and COL F (Hyperlink) to paste to sheet "Hitters"

Then, either in same macro or a different macro: look at COLA A and if it finds a "P", copy only COL B (Player Name) and COL F(Hyperlink) and paste to sheet "Pitchers"

Thanks for any assistance.

Something like:

Please Login or Register  to view this content.