Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



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

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 23-02-2012
Member
 
Join Date: Feb 2012
Posts: 14
Is there a way to populate one sheet data from another in Excel

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.

Reply With Quote
  #2  
Old 23-02-2012
Member
 
Join Date: May 2011
Posts: 410
Re: Is there a way to populate one sheet data from another in Excel

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: "" .
Reply With Quote
  #3  
Old 23-02-2012
Member
 
Join Date: May 2011
Posts: 446
Re: Is there a way to populate one sheet data from another in Excel

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.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Is there a way to populate one sheet data from another in Excel"
Thread Thread Starter Forum Replies Last Post
excel spread sheet data transfer help elijah58 Software Development 2 29-08-2012 04:24 PM
Want to copy Excel Chart to another sheet without the Data LuniA MS Office Support 5 25-02-2012 11:09 AM
How to add data in Excel when sheet protection is activated Lanka Boy Microsoft Project 2 08-01-2012 09:14 PM
Parsing data in Excel Sheet Ossi Windows Software 4 04-02-2011 07:55 AM
Identifying common data in an excel sheet Hebrew Windows Software 5 25-12-2009 06:57 PM


All times are GMT +5.5. The time now is 12:39 PM.