Try using the Advanced filter feature.. you'd have to put your 'criteria' on
a seperate worksheet (or should) but that could link to 2 worksheets.

"biscuitsmom" wrote:

I am trying to get 2 sheets to link together so that when I autofilter on
sheet1 the filter will also effect sheet2 and vice versa. Please help. I
have been working on this for a month now.