I have a series of data which is linked to one tab. I have seperated some information from this tab. I am hoping then i can add to the Macro to automatically filter results. For example i only want results which were Yes in Column H to be included.
Can someone please assist.
View best response
I have found the below. Will this work for the requirements below?
Dim range_to_filter As Range
Set range_to_filter = Range("H:H")
range_to_filter.AutoFilter Field:=1, Criteria1:="Yes"
You need only one line of code to filter the column H which is like this...
Range("A1").CurrentRegion.AutoFilter field:=8, Criteria1:="Yes"
Btw, you have placed the event codes on Standard Modules which is not the right place for them.
You should place the Worksheet_Change event code on the Sheet Module and Workbook_Open event code on ThisWorkbook Module.
Thank kindly for your assistance. I have updated the worksheets.
Thanks again, always much appreciated.
You're welcome @calof1!