I don't think that will work. I need to have the pull downs like in the
autofilter. To explain my problem more...I have used up all the columns that
excel allows you to have. I either need more columns or be able to link 2
sheets. The first 10 columns of information that will be shared between the
two sheets. This data is what is filtered on. Say for example in one of the
10 columns will have vehicle brand names and I only want to look at all
Toyota brand vehicles. I need the 2 sheets to show only the rows that have
toyota brand information.
"TomHinkle" wrote:

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.