I have a large worksheet, approximately 240 columns and 4000 rows. Sometimes
I need to create seperate workbook and add only specific columns where
specific criteria is met in some of the columns.
For example, if column B (column name "Date") = "01/01/2008"
and column AA (column name "Defect') ="Yes" and column CB (column name
"Type") = "Closed" and/or "Closed - No Action". I would like to pull those
rows of data into a new workbook or worksheet and copy/paste from there.

Is there some VBA code I can use. If someone could provide me with a basic
code, I could add form there. I already have a module written with all column
names identified. I am not real fluent at writing code but can update once
provided, pretty new at VBA.