VBA - Pretty basic IF statement help needed

Hi all,

I'm looking for some help with a code.

Specifically, this is what I need:

1) Search for "Tenure" - IF found do nothing, IF not found insert a column in B for "Tenure", and the appropriate code from below to determine tenure in years.
2) Search for "Age" - IF Found do nothing, IF not found insert a column in D for "Age", and the appropriate code from below to determine age in years

Please Login or Register  to view this content.

Basically the same thing, just different wording. In about 10% of the files we receive, people will sometimes only list Tenure and not DOH (date of hire) or Age and not DOB(date of birth) - I need it to check if they already have this information provided otherwise, it needs to run the code to insert this data.

Any help is appreciated.

NOTE: I need them to be seperate for the fact that sometimes we'll receive one and not the other. Thanks.