Excel 2010 Win 7


I have been trying to teach myself VBA. I am somewhat familiar with
programming but I can't figure this out. Can someone point me in the
right direction?

Thanks
Daphne

I have a spreadsheet with information about members of a club.

I need to copy some of the information to a new workbook depending on
the value of cell D in each row.

For example
if the value of cell A in row 1 is "T" then copy cells B1 to E1 to cell
B1 of the first empty row in a new workbook

but if the value is "F" then go to the next row and repeat the routine
until an empty row is found.

A B C D E
--------------------------------------------
T N Jim Smith 250-746-8888
F RN Susie Jones 250-749-2288
T RN Vanna White 250-743-1245