Cancelado

Write some Software

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.

EXECUTIVE SUMMARY

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.

Habilidades: Excel, Java

Ver más: software write mq4, software write chip epson, useful software write book, software write web specs, software write edid, software write websites idea, software write book images, software write books, software write protection, free software write book, software part time testers, software write book, software write technical manual, software part time

Información del empleador:
( 36 comentarios ) Sultan, United States

ID de proyecto: #12736666

2 los freelancers están ofertando un promedio de $278781 para este trabajo.

dghq123

Hi there.. I have read your project details completely and willing to do it for you... Check my recent reviews for our quality work on on time delivery :) Please inbox and we can discuss about project and I will re Más

$2000 USD en 30 días
(11 comentarios)
4.6
MiniBigTech

Hello there, We had a chance to go through your complete job description for getting your website build.We can assure you that we have all the skills and expertise that you require. We believe in 100% satisfaction Más

$555561 USD en 1 día
(0 comentarios)
0.0