I'm new to scripting within Excel, and I am wondering if it is possible to
write a script for an Advanced Filter where the Criteria Range is itself a
variable. I would like to filter the data in a spreadsheet with the data in
a single column of another sheet. Since the amount of data in this column
can change from time to time and selecting the entire column incudling blank
cells below the data doesn't work, I want to have the filter adjust
accordingly. Example script:

Range (.Cells). AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
Sheets ("Sheet1") .Range(VARIABLE RANGE HERE), Unique:=False

Thanks!