I am looking for a way to join two spreadsheets in two different Excel files. They both contain a list of names and addresses. One is a master list that includes other fields, and the other is a list that only includes name and address and an ID column that was pared down by another office. I want to use the second list to filter the first. Can this be done without using a macro?
September 9, 2013 1:33 PM
September 9, 2013 1:35 PM