Excel 2007 : Copying data filters from one sheet to another?

Hi All,

Could you help me with this one.

I have a list of datas in coloumns A,B,C,D,E,F in Sheet1.
And in sheet2 coloumn F of sheet1 is repeated again along with new coloumns G,H,I,J,K..

Now If I place filters in Sheet1, and select some values in column A&B there will be some values flitered in column F.

Now my question is Can we filter out in Sheet2 based on the filter applied on Sheet1?
That is ColoumnF in Sheet2 should have the same data filtered here and which in turn filters out rest of the coloumns(G.H..) in Sheet2. Makes sense?

thanks,
SK