A
Allison
Ok, so I made it filter one of the files, but now I have a
different problem. My first four columns are Last Name 1,
First Name 1, Middle Initial 1, Last Name 2. When I
filtered and copied to a new sheet, the program for some
reason populated column D, Last Name 2, with the data from
column A, Last Name 1. I tried it twice and it did the
same thing both times. This is the only column that was
affected; I thought it was because the column had blanks
in it but other columns also had blanks and were not
affected. Can anyone tell me why this happened?
different problem. My first four columns are Last Name 1,
First Name 1, Middle Initial 1, Last Name 2. When I
filtered and copied to a new sheet, the program for some
reason populated column D, Last Name 2, with the data from
column A, Last Name 1. I tried it twice and it did the
same thing both times. This is the only column that was
affected; I thought it was because the column had blanks
in it but other columns also had blanks and were not
affected. Can anyone tell me why this happened?