Need Help: Need to Highlighting correlating row

[Kansas10]

I am needing help!. How do I get the active row that i am working in (Row 3) to highlight along with the correlating row with the values (Row 16).?

 

[Luke M]

Hi Kansas, and welcome to the forum.

In the future, it's more helpful if you can upload an XL file we can work with immeidately, rather than an image that we'll have to recreate something from.

As for your question, the only way to detect the active cell would be by using a macro. Is this ok? If yes, right-click on the sheet tab, view code, paste this in

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim curCell As Range
Dim fCell As Range

'Check if we're in the range of interest
If Intersect(Target, Range("3:12")) Is Nothing Then Exit Sub

Set curCell = ActiveCell
Set fCell = Range("C:C").Find(Cells(ActiveCell.Row, "A").Value)

'Check if value in col A found in table below
If fCell Is Nothing Then Exit Sub
Application.EnableEvents = False
Union(ActiveCell.EntireRow, fCell.EntireRow).Select
curCell.Activate
Application.EnableEvents = True
End Sub

Close the Visual Basic Editor, and you should be good to go.

 

[Kansas10]

Hi Kansas, and welcome to the forum.

So how does this work for the next letters? like b-b c-c d-d etc.

 

[Luke M]

This line is what does that work

Set fCell = Range("C:C").Find(Cells(ActiveCell.Row, "A").Value)

It says to search col C for the value found in col A of the active cell's row. So, it doesn't matter whether col A has the letter a, b, c, d, etc.