Advanced Filtering

Hi Guys,

I want to be able to use an advanced filter to sort out specific criteria of exchange rates. I have the rates in a spreadsheet but I am not sure how to begin this process. From what I have read, I think I need to set up criteria but really I have no idea how to do this. Can someone give me an idea of where to start? The criteria that I would like to be able to sort would be date (years) and just compare specific exchange rates which would be specified through activeX controls. I have attached a file of the data I have.

Update:
Is it possible to use advanced filtering to move a specific range in excel to another worksheet. The range can change, since the information is being pulled from the web but it is always pulled in the same way so based on the cells around the desired range I think this can be done but I'm not sure how to do it. I have uploaded the new workbook and the range that I would like to copy is range("a28", "j31") into the other sheet under the correct column headings. But this range is only for this update, I would like to have a macro that can by dynamic with the changing range.

Thanks guys

Jimmy, this isn't exactly clear. Are you stating that you would like to move the entire range encompassing A28 over and down through J31, or each of those two cells specifically?

What is special about this particular range choice? Will it change over time? Is it based on criterion being developed outside of the workbook? Based upon the data you provided in the sample workbook, it appears random (a non-month ending or beginning date occurring in the middle of the data set in 1994).

A little clarification and I think we can get you going...