plasteredric
09-24-2017, 04:20 AM
I have two sheets in my workbook, one called "Template", the other "Upload"
On the template sheet I have a list of names in column A and a matrix from columns B to F.
On the "Upload" sheet i would like to be able to paste a list on names and to find the closest matching names from the list in the "Template" sheet, I then want to place a points value (from 1 to 3) in the correct row of the matrix on the "template" sheet, under the column that relates to the source of the list.
Hope that makes sense, if anyone can help.
20448
On the template sheet I have a list of names in column A and a matrix from columns B to F.
On the "Upload" sheet i would like to be able to paste a list on names and to find the closest matching names from the list in the "Template" sheet, I then want to place a points value (from 1 to 3) in the correct row of the matrix on the "template" sheet, under the column that relates to the source of the list.
Hope that makes sense, if anyone can help.
20448