Merging Columns from 2 sheets based on a common column

**skilaru** · 02-23-2012, 06:33 AM

Hello All,

I need some help to design a macro which can help me to merge columns from 2 sheets.I have Sheet1 with 4 columns including column Header "ID".I have around 19 coulmns in Sheet2 including column "ID" which is common on both sheets.I would like to get all the records in Sheets 1 along with matching data for the 18 columns from Sheet2 onto a seperate sheet Sheet3.
I have included the sample data in Sheet1 and Sheet2 and have provided the desired data set in Sheet3.
Can some one help me to transform the data to Sheet3.

Thanks in Advance.

**arlu1201** · 02-23-2012, 07:12 AM

All you need to use is vlookup. May not be just 1 but several.

First copy all your IDs (remove duplicates) into Sheet3. And then get the data from Sheet1 & Sheet2 into Sheet3 using vlookup.
For e.g. to get the Name from Sheet1, use this formula in B2 of sheet3 =VLOOKUP(A2,Sheet1!A:D,2,0).
To get the Currency1 from sheet2, use this formula in G2 of sheet3 =VLOOKUP(A2,Sheet2!A:S,4,0)

Let me know if you need more help with this.

**skilaru** · 02-23-2012, 07:21 AM

Hi Arlu1201,

Thanks for your response.But Can I have a macro which can do the above function and this can help me with a single click instead of doing VLOOKUP 18 times on Sheet2. And I have to do this exercise quite frequently and macro code would save lot of my efforts.

Please suggest.

Thank You.

**arlu1201** · 02-23-2012, 11:46 AM

You can use this code -

Please Login or Register  to view this content.

**Charles** · 02-23-2012, 02:02 PM

Hi,

This thread appears to be a duplicate of

http://www.excelforum.com/excel-prog...iple-rows.html

If it's not sorry, but, if it's the same question then close out the one you do not need.