+ Reply to Thread
Results 1 to 4 of 4

Macro to Consolidate Data from 3 Sheets to a Result Sheet

  1. #1
    Forum Contributor
    Join Date
    12-26-2015
    Location
    UAE
    MS-Off Ver
    2013
    Posts
    128

    Macro to Consolidate Data from 3 Sheets to a Result Sheet

    Hello All
    I am using excel 2010 and have the problem of Consolidating my Data from 3 Sheets (sample attached)

    SheetV has got Data (Name1, Name2 etc) from E3 onwards (I have colored it red for sake of explanation)

    SheetQ has got same Data (Name1, Name2 etc) from E3 onwards (I have colored it red).

    SheetD has the names of the Dept (currently 30+)

    I want a macro which should do the following consolidation for me. The macro should create the data as shown in the Result Sheet

    Col A1 – Head1 which should copy the current year and month in the format yyyymm
    Col B1 – Head2 which should copy the Data in Col B4 till last row from SheetV
    Col C1 – Head3 which should map the Dept names from SheetD (eg. Name1 should be replaced with Dept1, Name2 with Dept2 and so on)
    Col D1 – Head4 which should put the word CUR till down
    Col E1 – Head5 this value will come from SheetQ (colored green for explanation)
    Col F1 – Head6 this value will come from SheetV (colored blue for explanation)

    The ID Column may also not have the ID numbers in same order (Please see SheetQ and SheetV)

    The macro should allow to select the Range E3 onwards viz in the sample provided E3 to G13.

    As the sample I have shown is for few rows and in reality it is 2000+ rows of data and 30+ names

    Hope to get some help

    Thanks in advance

    Rehana
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    12-26-2015
    Location
    UAE
    MS-Off Ver
    2013
    Posts
    128

    Re: Macro to Consolidate Data from 3 Sheets to a Result Sheet

    Anybody to help me on this please?

  3. #3
    Forum Contributor
    Join Date
    06-03-2004
    Location
    India
    MS-Off Ver
    2013
    Posts
    205

    Re: Macro to Consolidate Data from 3 Sheets to a Result Sheet

    Any luck on this please?

  4. #4
    Forum Contributor
    Join Date
    12-26-2015
    Location
    UAE
    MS-Off Ver
    2013
    Posts
    128

    Re: Macro to Consolidate Data from 3 Sheets to a Result Sheet

    Hello all,
    I am posting a better sample of my requirements

    The IDs have been sorted now and filled with some Data and both SheetV and SheetQ
    I want the Result sheet.

    In the Result sheet no blanks or zero required from SheetV and SheetQ but I have filled the blanks with zero to make it more clear.

    Please help

    Thanks in advance.
    Rehana
    Attached Files Attached Files

+ 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] Macro to Create a Master Sheet and consolidate data as per Headings on all Sheets
    By prkhan56 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-21-2015, 01:32 PM
  2. How To Consolidate Data From Different Sheets to One Summary Sheet
    By Lawliet918 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 07-06-2015, 12:23 AM
  3. Macro to PRIORITISE and CONSOLIDATE data across different sheets into summary sheet
    By JamesGoulding85 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-31-2013, 07:49 AM
  4. Macro to identify specific rows in many sheets and consolidate onto one sheet
    By Ospenc1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-19-2013, 12:00 PM
  5. [SOLVED] Consolidate data from multiple sheets into one sheet
    By adil.master in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-04-2013, 02:41 AM
  6. Replies: 20
    Last Post: 06-20-2013, 09:04 AM
  7. Need macro to consolidate data from different sheets to single sheet
    By sekharyadav in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-18-2012, 03:20 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