TAPS_MikeDion
Well-known Member
- Joined
- Aug 14, 2009
- Messages
- 622
- Office Version
- 2011
- Platform
- MacOS
Hi everybody,
I haven't been able to figure this one out on my own.
I'll try to keep this as simple as possible. I need to search the rows of data for duplicate entries of Last Name (Col A), First Name (Col B) and Location (Col AB). I have 3 radio buttons used to select the sorting of the ComboBox drop-down list, which works fine.
The 3 sort buttons used are First Name, Last Name, and Location.
When the user clicks on a selection from the drop-down list it populates numerous labels with the associated information from a row in the Excel sheet. This works fine as well. However, when the user selects a line from the drop-down list, I also need it to search from A2 to last row looking to see if there are any duplicate last name, first name, and location entries (columns A, B and AB respectively).
Example:
<tbody>
</tbody>
In the above example, rows 2 and 5 match First Name and Last Name.
Also, rows 4 and 6 match completely.
To anyone that tries to help...THANK YOU!!!
I haven't been able to figure this one out on my own.
I'll try to keep this as simple as possible. I need to search the rows of data for duplicate entries of Last Name (Col A), First Name (Col B) and Location (Col AB). I have 3 radio buttons used to select the sorting of the ComboBox drop-down list, which works fine.
The 3 sort buttons used are First Name, Last Name, and Location.
When the user clicks on a selection from the drop-down list it populates numerous labels with the associated information from a row in the Excel sheet. This works fine as well. However, when the user selects a line from the drop-down list, I also need it to search from A2 to last row looking to see if there are any duplicate last name, first name, and location entries (columns A, B and AB respectively).
Example:
A | B | AB | |
1 | Last Name | First Name | Location |
2 | Smith | Joe | Site A |
3 | Doe | Jane | Site D |
4 | Claus | Santa | Site B |
5 | Smith | Joe | Site C |
6 | Claus | Santa | Site B |
<tbody>
</tbody>
In the above example, rows 2 and 5 match First Name and Last Name.
Also, rows 4 and 6 match completely.
- If Last Name and First Name match, I need to set the ".Value = true" on my radio button DuplicateFoundButton.
- If all 3 match, I need to set the ".Value = true" on my radio button DuplicateFoundButton and change a labels ForeColor (WarnOfMultipleLocations.ForeColor = &HFF&).
To anyone that tries to help...THANK YOU!!!