I've automated the clearing with these clicks:
![]()
Private Sub CommandButton1_Click() 'Clients Converted Range("D9:D" & Rows.Count).ClearContents Call GenList(4, "Yes", "D", "AH") End Sub Private Sub CommandButton2_Click() 'Clients visited Range("C9:C" & Rows.Count).ClearContents Call GenList(2, "", "AH", "C") End Sub Private Sub CommandButton3_Click() 'Clients called Range("B9:B" & Rows.Count).ClearContents Call GenList(0, "", "AH", "B") End Sub
Bookmarks