I have a table and say I would like to create a unique list from
column2 and store the list in a spearate sheet. Give this unique list
a name.

Use this unique list in a FOR EACH loop and apply autofilter to two
tables on two different sheets.
(one table is from which the unique list was created and other in a
different sheet)

I have attached a file wiith the table headers. In sheet2 there is a
table and i need to produce an unique list from column MODEL. and then
name that list separately.

Using this unique list I would like to autofilter the same table on
sheet2 and table on sheet3
simultaneously

Can this be done?
Any help is appreciated. I have been stuck in this for while now.

Thanks
vishnu