Please forgive my lack of brain functions today.

This may sound silly, but Ive been working with access for weeks and cant
wrap my brain around this problem in excel.

Its rather straight forward.
I have a large table some 19000 records.
Each record has 18 columns.
I want to select all records with a value from column # 12 that is equal to
variable €œA1€�.
Then take all matching records and copy to a new workbook and save.
Then do again with different value.

Dan