Autofiltering All Possible Entries Macro

[Horvy]

I have a collection of data which I am required to first filter by account number(Column A) and then by currency, Column B. However, the currencies for the account differ each day, (I will be running this macro daily) i.e for account 13132 it may not have anything for CAD today, but tomorrow it will. I am wondering what macro could be used to first autofilter the data by the account number, using auto filter, and then by each currency, copying the data for each currency to a seperate sheet each time.

Regards,

Horvy