Comparing between 2 worksheets and retreiving data if a match
I created “data input"worksheet which only contains the data for one record. After data is entered, it will be relocated to another worksheet labeled "location". I would like to compare the data in range E1:G1 (containing first name, mid initial, and last name) on my “data input" worksheet” against the data contained in columns E, F, and G of a multi-row worksheet, labeled "List". If any row of the multi-row worksheet "List" has an identical match in its Columns E, F and G, I would like to import all the remaining data in that row (columns H thru Z) into “the data input sheet”. All the worksheets involved are in the same workbook. Thanking all in advance for any assistance regarding this.
|
02-13-2017, 01:25 PM
Similar Threads
comparing data
Windows 10 
Office 2016
Threaded Mode