Unique Advanced Filter to new sheet using dynamic range

Hi,

I have spent some time googling this with no success. I would like to alter this:

Sub FilterCopyToOtherSheet()
    Sheets("Raw Data").Range("B1:B12").AdvancedFilter _
        Action:=xlFilterCopy, _
        CriteriaRange:=Sheets("raw data").Range("B1:B12"), _
        CopyToRange:=Sheets("Risk Summary").Range("D7"), _
        Unique:=True
 
End Sub

End Sub


So it automatically find the last row based on on column b. This will help with one part of my problem in the post:

HTML Code: 

Can anyone help?