Write some Software

  • Estado Cerrado
  • Presupuesto $10 - $1000000 USD
  • Total de ofertas 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.

Obtén cotizaciones gratis para un proyecto como este
Habilidades necesarias

¿Buscas ganar algo de dinero?

  • Fija tu plazo y presupuesto
  • Describe tu propuesta
  • Recibes pagos por tu trabajo

Contrata Freelancers que también oferten en este proyecto

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