Is there a way to populate one sheet data from another in Excel

[M.N.S]

I have 2 sheets in the excel file. On the first sheet the first column is a part num only. The second sheet has part num on the first column and descriptions on the second column. I need a macro or script that will scan the second sheet for part num that matches the first sheet part num and populate the description(at the second column) on the first excel sheet.

[Essien]

There is one way to do that. Assuming the reference data is in Sheet2, cols A and B col A = part#, col B = description in Sheet1 with col A containing part# in A2 down. Put in B2: =IF(ISNA(MATCH(A2,Sheet2!A:A,0)),"",VLOOKUP(A2,She et2!A:B,2,0)) then copy down Col B will return the descriptions corresponding to the part# in col A. Unmatched part#s will return blanks: "" .

[GaganjyotTechie]

You can do that by giving a = and then linking the content from another sheet. Just type = and hit enter. In the same way you can simply drag the cell to get entire data from another sheet. If only = does not work you can use @ with it.