I have created an spreadsheet with 3 sheets:
Sheet1 - Search
Sheet2 - Add Data
Sheet3 - Database
I want to create a button (Update) to highlight rows (green) for value of cell D4 Sheet1 and highlight rows in Sheet3 (in column 1 i have data which i need to insert in D4 to highlight). I have created one button but everytime just highlight the last row from Sheet3
Private Sub MDAno_Click()
currentrow = Sheet3.Cells(1, 1).CurrentRegion.Rows.Count
If Len(Range("D4")) <> 0 Then
Sheet3.Cells(currentrow, 498) = "Investigating"
End If
End Sub
I have a condition in Sheet3 (if i have "investigating" in column 498 highlight row). Can somebody help me with this ? Thanks