I have written code (see attached) that works by looking at the column containing the first name
of an individual, as I had assumed that a first name would always be included (the data to be
inputted comes from various external sources). This turned out not to be the case. However,
either the first and/or last name is always included. So I need to modify this code to have the
procedure look at both columns. I tried modifying the range to include both columns, but this
resulted in a situation where the persons with both first and last names are displayed twice. I'm
not sure how to alter the code to get it to look at both columns, and to only respond once per
row if there is data in either the first or last name column, or both columns.
Attached I've included a example of the data to be inputted ("test data.xlsx"), and the program
that is to import these sheets ("27Dec11 - MasterArmingRoster.xlsm").
Thanks for any help,