+ Reply to Thread
Results 1 to 5 of 5

VBA Code to Consolidate Multiple Sheets with Multiple Criteria

  1. #1
    Forum Contributor
    Join Date
    12-16-2015
    Location
    Bangalore
    MS-Off Ver
    MS 365
    Posts
    134

    VBA Code to Consolidate Multiple Sheets with Multiple Criteria

    Hi All,

    Attached is the Data file which I have where performance data is in different sheets along with the Employee Code, Frequency, Date, Name.

    Data from E Column in all the sheets are performance data.

    I would like to have a VBA Code where the code runs and consolidates data from all the sheet into New sheet and remove duplicates from column (Employee Code, Frequency, Date, Name) and capture data from E to all columns as from all the sheets per the Employee Code, Frequency, Date, Name.

    I have removed the Employee Code and shown as "-". This will be unique for each employee.

    Let me know for any clarifications.

    Regards,
    Yadavagiri
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    12-16-2015
    Location
    Bangalore
    MS-Off Ver
    MS 365
    Posts
    134

    Re: VBA Code to Consolidate Multiple Sheets with Multiple Criteria

    can anyone please help me

  3. #3
    Forum Contributor
    Join Date
    12-16-2015
    Location
    Bangalore
    MS-Off Ver
    MS 365
    Posts
    134

    Re: VBA Code to Consolidate Multiple Sheets with Multiple Criteria

    please help - if anyone not able to understand the request - please let me know.

  4. #4
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    6,602

    Re: VBA Code to Consolidate Multiple Sheets with Multiple Criteria

    Administrative Note:

    We don't expect you to bump threads more than once in 24 hours - it has been only an hour since you posted. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

  5. #5
    Forum Contributor
    Join Date
    12-16-2015
    Location
    Bangalore
    MS-Off Ver
    MS 365
    Posts
    134

    Re: VBA Code to Consolidate Multiple Sheets with Multiple Criteria

    Sorry Team

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Vba code to consolidate multiple sheets to one
    By aparnawangu in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-17-2017, 01:01 PM
  2. Consolidate multiple sheets
    By simonexcelhelp in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-30-2015, 03:47 AM
  3. VBA Code to consolidate sheets from multiple workbooks into one workbook
    By d247 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-10-2014, 02:53 AM
  4. Code to copy a row from multiple sheets to a summary sheet per criteria
    By rmwindham in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-29-2014, 11:05 AM
  5. VBA code to consolidate coloumns in muliple sheets into multiple coloumns in one sheet?
    By BrettRCourtney in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2013, 09:17 AM
  6. [SOLVED] VBA code to consolidate coloumns in muliple sheets into multiple coloumns in one sheet?
    By BrettRCourtney in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-13-2013, 06:19 AM
  7. Consolidate multiple sheets
    By scottb in forum Excel General
    Replies: 10
    Last Post: 06-16-2010, 05:01 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1