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.
Hello! I'm a Computer Science student, In my free time I develop desktop apps and websites, I'm really good working with excel spreadsheets in C#, so working them in Java should be no problem. Thanks for reading!