Cerrado

Write some Software

Este proyecto recibió 2 ofertas de freelancers talentosos con una oferta promedio de $278781 USD.

Obtén cotizaciones gratis para un proyecto como este
Presupuesto de Proyecto
$10 - $1000000 USD
Ofertas Totales
2
Descripción del Proyecto

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 Requeridas

Buscando hacer algo de dinero?

  • Establece tu presupuesto y período de tiempo
  • Describe tu propuesta
  • Consigue pago por tu trabajo

Contrata Freelancers que también oferten en este proyecto

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online