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
I forgot a preparation step that wee need to collect all data from all other files (example: Source1, source2,...anothersource3...)into one SourceFile.xls. Therefore, we will need another button to collect data first. This button will work:
For each file in folder1, copy all data and paste into the next line of SourceFile.xls and delete that file.
Finally, we will have only one SourceFile.xls and proceed the Finding tasks.
18 freelancers are bidding on average $32 for this job
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