WHAT WE HAVE
X1. Excel file A (xlsx) that needs to be formatted, and have data appended.
X2. Excel file B (xlsx) that has table of data to be appended to Excel file A.
WHAT WE NEED
Y1. Rename Excel file A to add an "X" to the end of the file name, just before the file extension.
Y2. Excel file A - check and convert date column to date only if contains date and time.
Y3. Vlookup data in Excel File B and append to Excel file A.
Y3. Create spreadsheet report of data in Excel File A not matching any data in Excel File B during Vlookup performed in step Y3 above.
Y4. Save all three spreadsheets: Excel File A with newly appended data, Excel File B with no changes, and Newly created Excel File C with all lines of data from Excel file A that did not receive a match from Excel File B during the Vlookup process.
1. Review Excel source file for date modification, save with new name, then append data, with vlookup, from a static Excel data table.
2. Create new Excel file containing unmatched lines from source Excel file, after vlookup has been performed.
We also need the java source code and list of libraries needed to make the source code work.