Previous Topic Next Topic

Comparing & replicating data, 2 Excel sheets

Closed
Miguel - Jun 2, 2011 at 01:24 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 2, 2011 at 05:57 PM
Hello, all. I have 2 sheets of a spreadsheets I'm looking at in Microsoft Office Excel 2007. On the first sheet: a) I have 300,000 rows of user information; b) Columns A, B, C, D, & E contain ID numbers, first names, last names, addresses and states, respectively. The second sheet contains about 800 partial records from the first sheet (columns A, B, and C only). I need to compare the first columns on the sheets, and if the ID numbers match, the information in columns D and E (from sheet 1) needs to be copied to the corresponding ID numbers in (columns D and E) on sheet 2.

Thanks in advance for the assist.
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 2, 2011 at 05:57 PM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note: your data need not be to be real data but a good representative of how data looks like