I am looking for a macro do the following:

1. Download a an excel file from this link http://blue.usps.gov/delret/L3do/dsy...tLakes3999.xls
2. When File Opens, I want it to filter Column C to show only "481" results.
3. Once the file is filtered, I then want it to copy range(F2270:BJ6000) and paste. special with formating into the the workbook where the macro is running from to Sheet("3999 Data") starting at (B2)