I have a list of data some with people titles, others with it missing. what i plan on doing is
D is the collum for title some are entered others are not. collum G has male and female already filled in.
is there a code to say if D is empty then look at G if it is female enter Ms in collum D and if male enter Mr in collum D.
Thanks
Bookmarks