I need some guidance as to where to start with this, pseudocode will be fine.
Here is an example of my sheet
First Name Last Name HouseHoldName HHID
John Doe 123
Jane Doe 123
Bob Frank 456
I have already uniquely identified members of a household, now what I would like to do is have a vba macro that will take the value in the HHID field and search the entire range for duplicate values. I will then do an If...Then or Select Case that will add values to the HouseHold Name column based upon how many duplicates are found. I can do this manually in Access, but it can be quite tedious, even for a small file.
I'm not familiar with Excel vba though, so I have difficulty knowing where to start. Although I have done some Access VBA, as well as VB.net work.
Thanks for the help!