Combining data from two worksheets into one?
Posted by Brad Taplin on September 19, 2001 12:12 AM
I am under the gun to combine data from two worksheets into one. The 26 fields and column formats are the same, but the 17,000+ rows in each differ somewhat.
Each of these sheets contains a few records not in the other, and for every record different fields populated in different sheets. Only one sheet, for instance, has a VoterID listed for every entry, and only the second sheet has anything in the Comments field.
Here's an example: in Sheet1 Joe Blow at 123 West Snow Street may be row 9, where Sheet2 may have him in row 5. Joe's Sheet1 record includes a VoterID, and Joe's Sheet2 record includes some comments. We need one worksheet to contain everything about Joe, once. The combined sheet must also contain all records that had been unique to one or the other worksheet.
Please advise ASAP. I have been advised to try VLOOKUP but am no expert in Excel. I need step-by-step advice, not necessarily specific to my particular sheets but specific to this general challenge.
Thanks in advance.
P.S. I do Excel on a PC though I use a Mac for email.