This is an easy task. Do not bid more than minimum.
1. Create a button in Sheet2 of SourceFile.xls. At the beginning, Sheet2 has one column with data (A)
2. For each line column A in Sheet 2, find all the records (lines) that the value in column B in Sheet1 of [url removed, login to view] is the same as column A in Sheet2
3. Copy all found records (lines) and make a new file [url removed, login to view] that the content (columns) is the same as [url removed, login to view]
4. In Sheet2, write the “found values” in column B and “not found” for value that cannot be found in column B of Sheet1
18 freelanceria on tarjonnut keskimäärin 32 $ tähän työhön
Yes, it is an easy task. It can be done with macros and few functions in visual basic. I am always working with excel and macros. So If you want to see any similiar work I have done in excel please send a PM