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.
9 freelancers están ofertando el promedio de $69 para este trabajo
Hello I have more than 5 years experience and I can help you to do your job accurately, quickly and with high quality, available 24/7 to support you and promise I will meet your expectations. Regards
Hello I'm able to make you a android program for that. & if you give me time then will provide you java desktop application for that. Regards Atiar Talukdar