Merge data from several excel worksheets

  • Status: Closed
  • Prize: $30
  • Entries Received: 2
  • Winner: elqueabandona

Contest Brief

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.

Recommended Skills

Top entries from this contest

View More Entries

Public Clarification Board

  • tuSOLUCION
    tuSOLUCION
    • 5 years ago

    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.

    • 5 years ago
    1. deccani
      Contest Holder
      • 5 years ago

      Hello - How long would it take for you to develop the MS Access solution?

      • 5 years ago
    2. NourElDeen
      NourElDeen
      • 5 years ago

      I can do it 2 days

      • 5 years ago
  • CarolinaCardoza
    CarolinaCardoza
    • 5 years ago

    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.

    • 5 years ago
  • NourElDeen
    NourElDeen
    • 5 years ago

    Sir, What if you build a system using access it will be easy and collected into 1 place with friendly user interface #increaseprize #increaseprize

    • 5 years ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!