Start your advanced filter process from your End Result sheet.
That will allow you to select export range as End Result.
List Range would be... "'Source Data'!$A$1:$G$6"
Criteria range "'Filtered Data - End Result'!$E$2:$F$3"
Copy to: "'Filtered Data - End Result'!$A$1:$C$1"
As long as you have exact match for header records you want (Name, Temp Address, Date) in A1:C1 range. It will pull the info meeting your criteria.
Once done. Excel will created 2 named ranges. 'Filtered Data - End Result'!Criteria and 'Filtered Data - End Result'!Extract.
You can use these for future operation.
As for second question, you can use small macro to do it.
Ex:
Sub AdvFilter()
Sheets("Source Data").UsedRange.AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Range("'Filtered Data - End Result'!Criteria"), CopyToRange:=Range( _
"'Filtered Data - End Result'!Extract"), Unique:=False
End Sub
Bookmarks