+ Reply to Thread
Results 1 to 4 of 4

Merging sheets with different structures maintained at different granularity into a master

  1. 09-23-2016, 01:27 PM #1
    Presh
    Presh is offline
    Registered User
    Join Date
    09-23-2016
    Location
    Chicago, IL
    MS-Off Ver
    2007
    Posts
    2

    Merging sheets with different structures maintained at different granularity into a master

    Hey,

    I am struck up with a problem where I need to merge different sheets which have different structures maintained at different granularity into a master sheet which has all the columns available in the other sheets.

    Basically I need to populate all the data present in other sheets into appropriate fields in the master sheet and leave the rest as blank because the structures are not going to be the same.

    The users would fill the data in other sheets and once they are done I need to be able to populate the master sheet with corresponding values. There might be number of rows of data present in each sheet.

    I have attached a sample excel with 5 different tabs which need to go into the master file.

    Appreciate your help.

    Thanks,
    Presh
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-23-2016, 03:30 PM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Merging sheets with different structures maintained at different granularity into a ma

    1) delete that column A to move everything to starting position in A1.
    2) This macro goes into Master sheet module and it will run itself every time you bring that particular sheet onscreen.
    3) The macro is dymamic, it will
    ----match the row 4 headers to the row 4 headers on every other sheet and copy in those columns correctly
    ----find the first KPI category in row 3 of each sheet in row 3 of the master, then copy all the data as a mass group all at once.(it is presumed your groups are all in the same order within a group)

    Please Login or Register  to view this content.
    Attached Files Attached Files
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
  3. 09-23-2016, 05:51 PM #3
    Presh
    Presh is offline
    Registered User
    Join Date
    09-23-2016
    Location
    Chicago, IL
    MS-Off Ver
    2007
    Posts
    2

    Re: Merging sheets with different structures maintained at different granularity into a ma

    Amazing job JBeaucaire. I was really stunned that it was so fast. I shall try it out and get back to you if I have any questions.

    Really appreciate your help.
    Reply With QuoteRegister To Reply
  4. 09-23-2016, 07:19 PM #4
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Merging sheets with different structures maintained at different granularity into a ma

    Glad to help. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

    It is customary to give feedback to those that have helped you by clicking on the asterisk (Add Reputation) at the bottom of their post.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Vlookup at different granularity / concatenate
    By cks1026 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 06-27-2016, 05:41 AM
  2. merging sheets in different workbooks into a master sheet
    By bardosi.m in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2015, 12:44 PM
  3. [SOLVED] Adding rows while merging sheets into a master sheet
    By sbidgol in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-11-2014, 10:00 AM
  4. Merging Data from Multiple excel sheets to a Master sheet
    By dilli34 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-19-2013, 12:26 AM
  5. [SOLVED] Comparing 2 configuration sheets, and merging them together to 1 master list
    By ne0tec in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-11-2012, 09:04 PM
  6. [SOLVED] Merging multiple sheets onto one master sheet
    By pompeydave in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-09-2012, 07:56 AM
  7. Merging: displaying which sheet data comes from when merging sheets
    By zed commander in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-12-2012, 12:20 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1