Hey all,
I need to compile a list of computer names based on pulling data from two separate spreadsheets.
I have one spreadsheet (AKA users) with usernames and another spreadsheet (AKA computers) with usernames and the computer name associated to that user.
I need to go through each row in the users spreadsheet, one by one, copy the contents of the cell, find that username in the computers spreadsheet, then copy the associated computer name to another spreadsheet (AKA master).
Is there a way to automate this process?
I would just do this manually, but there are hundreds of rows to go through.
FYI, I can consolidate the contents of the spreadsheets into separate worksheets of one spreadsheet if that makes this any easier.
Thanks in advance for any help with this!
Bookmarks