Annulé

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.

We also need the java source code and list of libraries needed to make the source code work.

Compétences : Excel, Java

Voir plus : software write mq4, software write chip epson, useful software write book, software write web specs, free software write user guide, software write edid, free software write company profile, software write websites idea, software write book images, software write books, delphi file last write time, software write protection, free software write book, software part time testers, software write book, write query display current data label column date, write web page receive xml, flex software real time stock chart, software write protect software, software write technical manual, software part time

Concernant l'employeur :
( 37 commentaires ) Sultan, United States

N° du projet : #12736666

2 freelance ont fait une offre moyenne de 278781 $ pour ce travail

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 Plus

2000 $ USD en 30 jours
(11 Commentaires)
4.6
MiniBigTech

Hello there, We had a chance to go through your complete job description for getting your website [url removed, login to view] can assure you that we have all the skills and expertise that you require. We believe in 100% satisfaction Plus

555561 $ USD en 1 jour
(0 Commentaires)
0.0