Hi,

You may want to refer to question 7 on the following link -
http://ashishmathur.com/knowledgebaseII.aspx

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"LiAD" wrote in message
...
Hi,

I am looking for a formula that can act as a filter.

In sheet AA I have a table with headings products, date, diameter etc
starting from col A.

I would like in sheet BB to be able just to see data corresponding to a
certain product, call it Cars. The user enters Cars in B2 sheet BB and
the
formula fills in the table in sheet BB with only the data for Cars from
sheet
AA.

Is this possible without code?

Thanks