Hi, i have an excel question to ask, might need scripting, not sure yet.
in same excel 2010 file.
sheet1 has name and installed as two columns
sheet2 has computername as a column
there are about 600 records in sheet1
there are about 300 records in sheet2
if a record in sheet1 matches any records in sheet2, then i would like to input a Yes as text in sheet1 installed column.
does any one know how to deal this faster?
thanks a lot.