Beginner vba user.
I'm trying to create a function that will allocate the correct client_id in cell C2:C6, using the House and the Date values.
One House could have had multiple client_ids over time, so I need to allocate the correct client_id based on the Joining Date.
The function needs to find all instances where the House value is the same in the range A9:C13.
Below is the desired outcome:
The first step is setting the range, and then looping through this range for column B to find all instances where the house number matched the value in this column.
If I set the known range:
Dim rng As Range: Set rng = Application.Range("Data!A10:C13")
How do I loop over this range for column B?
