Publicar un concurso

Merge data from several excel worksheets

Estado: Closed
Premio: $30
Propuestas recibidas: 2
Ganador: elqueabandona

Winner

Resumen del concurso

Project involves creating Excel Macro or VBA script to merge data from multiple excel worksheets to single worksheet. Update the single worksheet (merged data) with elements from another excel workbook based on value match in column A.

Please see the attached image of sample excel workbook. Data from worksheets: Eyx, Eyx-Per, Nda, Oop, Lab, lew, Fas1, FasX, Ver and Eau is merged into Consol_List. Data in Columns L thru Z on Consol_List worksheet is populated from another excel workbook (Master Data) based on the value match in column A (IDS) on both workbooks.

I'm looking for someone to work on the project immediately with a quick delivery of 1-2 days max. Please bid only if you meet the criteria.

Habilidades recomendadas

Winner

Publica un concurso similar

Principales propuestas de este concurso

elqueabandona Argentina

0
CarolinaCardoza Venezuela

0

Tablero de aclaración pública

tuSOLUCION
- 6 años atrás
Hello friend, my name is Henry, I recommend you use Microsoft Access. In Microsoft Access you can make relationships between the tables that you require, make query tables and then export them to Excel if you require it. I am available to help you, I have knowledge of Excel and Access.
- 6 años atrás
1. Organizador del concurso
  - 6 años atrás
  Hello - How long would it take for you to develop the MS Access solution?
  - 6 años atrás
2. NourElDeen
  - 6 años atrás
  I can do it 2 days
  - 6 años atrás
CarolinaCardoza
- 6 años atrás
I just posted my entry in order to be consider for future projects. I have solved the issue taking in consideration some premises. Code does the required tasks.
- 6 años atrás
NourElDeen
- 6 años atrás
Sir, What if you build a system using access it will be easy and collected into 1 place with friendly user interface #increaseprize #increaseprize
- 6 años atrás