Hi everyone,
I am trying to figure out a way to easily do this task.
I have an Excel file containing a list of people. This list is i
"Sheet1"
The headers for each column in this list a
Column A
Dept. Name
Column B
Last Name
Column C
First Name
Column D
Email Address
Column E
Newtork ID
I have another list in "Sheet2"
The headers for each column in this list a
Column A
Name
The names in this column are formatted as "First name space Last Name"
for instance, "John Doe" .
What I want to do is compare the names in Column A on "Sheet2" wit
Column B and Column C in "Sheet1"
If they are the same name, then copy Column A, D and E into "Sheet2
and remove the row containing matching the name in "Sheet1"
Thanks in advance for any help.
Mar
--
Message posted from
http://www.ExcelForum.com