Copying rows based on criteria HELP ASAP

[tfreeze]

I have a worksheet with information from drawings / blue prints. It consist of columns A through O and can be from 10 to 10,000 rows long. In columns "I" and "J" I have a drop down box with the options of "Y" or "N". I want to open a new workbook and have certain cells of a row copied automatically to the new workbook based on if columns "I" and "J" have either a "Y" or a "N".

Basically, if column "I" has a "Y" in it I want columns "A" thru "H" to populate in a new workbook and if column "J" has a "Y" in it I want columns "A" thru "H" and "N" thru "O" to populate in another separate workbook.

I have never used anything other than formulas in excel.

Any suggestions.

 

[RCBricker]

I have a worksheet with information from drawings / blue prints. It consist of columns A through O and can be from 10 to 10,000 rows long. In columns "I" and "J" I have a drop down box with the options of "Y" or "N". I want to open a new workbook and have certain cells of a row copied automatically to the new workbook based on if columns "I" and "J" have either a "Y" or a "N".

Basically, if column "I" has a "Y" in it I want columns "A" thru "H" to populate in a new workbook and if column "J" has a "Y" in it I want columns "A" thru "H" and "N" thru "O" to populate in another separate workbook.

I have never used anything other than formulas in excel.

Any suggestions.

well not going to be a formula.

what is the name of the sheet with the "Y"s and "N"s?
if Y in I are you creating a new workbook or does it exist? What is its name if it exists?
The separate workbook for when there is a "Y" in J, what is its name and what path?