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
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
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By sspreyer in forum Excel Programming / VBA / Macros
Last Post: 12-13-2014, 11:00 AM
By macrorookie in forum Excel Programming / VBA / Macros
Last Post: 02-10-2014, 10:26 PM
By seider in forum Excel General
Last Post: 06-11-2013, 10:40 AM
By markdh in forum Excel General
Last Post: 11-15-2012, 09:15 PM
By albatr0n in forum Excel General
Last Post: 08-24-2012, 03:41 PM
By koolguys4u in forum Excel Programming / VBA / Macros
Last Post: 03-22-2012, 02:06 PM
By karinmpfa in forum Excel Programming / VBA / Macros
Last Post: 04-24-2006, 08:15 PM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1