+ Reply to Thread
Results 1 to 2 of 2

group matching and insert group of relevant data

  1. #1
    Registered User
    Join Date
    10-26-2015
    Location
    hong kong
    MS-Off Ver
    2013
    Posts
    1

    Exclamation group matching and insert group of relevant data

    I am working on excel with two work sheet. In the worksheet1, its the master data and has different items no. In the worksheet2. its the reference data that has the range of components of the items in the worksheet1. The components in worksheet2 has the same items no. as the the parent items in worksheet 1. So is there any fast method to link up the components in wokrsheet2 with the parent items in worksheet1 by matching there items no? By linking them together, I can to copy and insert the components' info in other columns of worksheet2 respectively as well.


    I just tried to sort the same item no. in worksheet2 to find components and copy and insert them back to the master data in worksheet1 with respective item no. But wasted me a lot of time, is there any better way in doing this?

    Please help thanks

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2212
    Posts
    37,063

    Re: group matching and insert group of relevant data

    Hi there... and welcome to the Excel Forum. Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    The paperclip icon
    Glenn



+ 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] insert a row to every group and change color of every top row of group
    By sspreyer in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-13-2014, 11:00 AM
  2. Replies: 1
    Last Post: 02-10-2014, 10:26 PM
  3. How to insert a group between group
    By seider in forum Excel General
    Replies: 6
    Last Post: 06-11-2013, 10:40 AM
  4. Replies: 11
    Last Post: 11-15-2012, 09:15 PM
  5. Replies: 5
    Last Post: 08-24-2012, 03:41 PM
  6. How to Insert New Group in Subtoal Group
    By koolguys4u in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-22-2012, 02:06 PM
  7. [SOLVED] Macro to sort data, insert a line after each group & then total?
    By karinmpfa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-24-2006, 08:15 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1