Hi All,
I was wondering if anyone can help with the following:
I have set up an advanced filter in Excel 2007 to filter data from a master spreadsheet (Download) into seperate sheet (MI)
The Advanced Filter details look like this:
List Range: Download!$A$1:$AK$100
Criteria range: MI!Criteria
Copy to: MI!Extract
Is there a way to use VBA to auto refresh this filter if new data is added into the Download sheet?
I have very little VBA knowledge so any advice woul be great.
Thanks,
Andrew
I was wondering if anyone can help with the following:
I have set up an advanced filter in Excel 2007 to filter data from a master spreadsheet (Download) into seperate sheet (MI)
The Advanced Filter details look like this:
List Range: Download!$A$1:$AK$100
Criteria range: MI!Criteria
Copy to: MI!Extract
Is there a way to use VBA to auto refresh this filter if new data is added into the Download sheet?
I have very little VBA knowledge so any advice woul be great.
Thanks,
Andrew