AndrewGKenneth
Board Regular
- Joined
- Aug 6, 2018
- Messages
- 59
Hi there,
I am having a problem with trying to get my spreadsheet to filter automatically. To explain my problem I have a spreadsheet ("Sheet2") and in column A is the value that will be filtered. In column A i want only the values that are "TRUE" to show. For example, if A1 is True the values in A2 and A3 will show, if A1 is not True A2 and A3 will be filtered.
The problem i am having is that when True values are updated in column A the filter is not automatically updating. The code
Private Sub Worksheet_Change(ByVal Target As Range)
Activesheet.Autofilter.Applyfilter
End Sub
Does not work because it only updates the cells that are hidden and does not automatically refresh the TRUE values that will be visible. Can anyone help please?
I am having a problem with trying to get my spreadsheet to filter automatically. To explain my problem I have a spreadsheet ("Sheet2") and in column A is the value that will be filtered. In column A i want only the values that are "TRUE" to show. For example, if A1 is True the values in A2 and A3 will show, if A1 is not True A2 and A3 will be filtered.
The problem i am having is that when True values are updated in column A the filter is not automatically updating. The code
Private Sub Worksheet_Change(ByVal Target As Range)
Activesheet.Autofilter.Applyfilter
End Sub
Does not work because it only updates the cells that are hidden and does not automatically refresh the TRUE values that will be visible. Can anyone help please?