I've seen some similar questions but can't find one that fits what I need. Here's my problem.
I have two different spreadsheets. Both spreadsheets have the "Computer Name" in column A. I need to match the "Top Console User" in column C, "Last Name" in column E and "First Name" in column F that matches the "Computer Name" in sheet 1 to the "Computer Name" in Sheet 2 and place this info in columns F, G, and H respectively of Sheet 2. Both sheets are in the Computer user list.xlsx file.
Ex: Sheet 2
A F G H
Computer Name
Sheet 1
A C E F
Computer Name Top Console User Last Name First Name
I want the information on Sheet 1 to match the information on sheet 2. Sheet 1 has 9000 names but I only need 500 of them pulled out for sheet 2. I want to paste the Top Console User in column F on Sheet 2, Last Name in column G and First Name in column H of Sheet 2.
What is the best way to do this?
Thanks,
cc
I have two different spreadsheets. Both spreadsheets have the "Computer Name" in column A. I need to match the "Top Console User" in column C, "Last Name" in column E and "First Name" in column F that matches the "Computer Name" in sheet 1 to the "Computer Name" in Sheet 2 and place this info in columns F, G, and H respectively of Sheet 2. Both sheets are in the Computer user list.xlsx file.
Ex: Sheet 2
A F G H
Computer Name
Sheet 1
A C E F
Computer Name Top Console User Last Name First Name
I want the information on Sheet 1 to match the information on sheet 2. Sheet 1 has 9000 names but I only need 500 of them pulled out for sheet 2. I want to paste the Top Console User in column F on Sheet 2, Last Name in column G and First Name in column H of Sheet 2.
What is the best way to do this?
Thanks,
cc
