Put data from one sheet into another if it meets certain criteria using a formula

[tbrynard01]

I have a worksheet with the following columns:
Workbook 1

Col A - Gender

Col B - Program

Col C - First Name

Col D - Last name

I would like to have another workbook update with all the Male clients only every time a new entry is added to Workbook 1 - the structure of the other workbook is:
Workbook 2

Col A - First Name

Col B - Last Name

Col C - Program

I have done something similar before, but don't do it very often so can't remember how I made it work

Any help will be appreciated.

 

[Zot]

You should update your profile to show what version of Excel you are using. Newer version has more function that can result different formula than older version and most likely simpler.

 

[tbrynard01]

You should update your profile to show what version of Excel you are using. Newer version has more function that can result different formula than older version and most likely simpler.

This question is for Excel 365 Version 2008. Thanks.