I have two worksheets in Excel 2007 and am trying to automatically fill in cells in worksheet two based on values in the first worksheet. Any assistance in code would be greatly appreciated!
Both worksheets contain name, lastname, address, phone of people (no unique identifiers though). Some of these people's details are repeated in worksheet2. Whenever an identical name (first name, last name) is typed into the second worksheet, I would like the contact details fields in worksheet 2(address, phone number, etc) to be filled automatically.