Hi,
I have a workbook that contains one sheet with a detailed transaction list, e.g.:

A B C D
1 Type Month Year Amount
2 Creditors 1 2015 10
3 Creditors 2 2015 12
4 Debtors 1 2015 15
5 Expenses 1 2015 20
6 Expenses 1 2015 30

On this sheet I have turned on the filter by column name

I have another sheet in the same workbook that summarises the detail data, e.g.:

A B C
1 31/01/2015 28/02/2015
2 Creditors 10 12
3 Debtors 15 0
4 Expenses 50 0

What I would like to do is either have the amounts in the summary page as hyperlinks that, when clicked, open up the first detail sheet and set the autofilter for Type, Month and Year based on the corresponding values from the summary sheet in row 1 (for month and year) and column A (for type). Or I would be happy to use a command button so that you select a cell in the summary sheet and then click on a button to open up sheet 1 with these filters applied.

Thanks