I need .xlsm Excel file that can import and process one or more TSV files (TAB separated values) and compare the values with previously imported data and dump the results in CSV files.
All of these points must be met:
- There must be a "settings" sheet that will contain different variables.
- The files must be imported automatically, file names/paths will be listed in the Settings sheet
- The TSV can contain one or multiple columns
- The values need to be compared (exact match - although not Case Sensitive)
- The results will be exported into 2 text files: "Identical" and "Different" in a new folder (Folder name = Date Time - eg.: D:\[url removed, login to view] 1730)
- In the "[url removed, login to view]" file, I want to have the names of the files that were identical after comparison
- In the "[url removed, login to view]" file I want to have the following values: "filename,original_text,new_text"
24 freelancers are bidding on average $68 for this job
Dear Sir I am Eqram. I am a new freelancer but i am hard worker and responsible to my duty. Please give me a chance to the project. I am not disappointed to you. Best regards and Thanks.
Hi, I have 3 years of macro building. Currently work on building macros on a weekly basis for my current position. Would be happy to work on this project. thusnani