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
Bookmarks