Finding values in a number of columns

[Moire]

Hi

I am relatively new to excel vba, but I am looking for some advice about creating a macro that I can run over a number of worksheets in a workbook.

The advice I am looking for is to take 3 columns where I can find certain values in those columns. Where a row has a value in each of those 3 columns that is met to save those rows along with all the column headings into a new worksheet in the same workbook. So, if I have 10 worksheets in my workbook and run the macro, I need to end up with 20 worksheets.

Can anyone help me?

 

[ClimoC]

Can you give us more info about what and where the columns are?

 

[Moire]

All of the worksheets in the workbook have the same number of columns. Columns A through to BV. I am only interested in 3 columns - AB, AK and BB. In those columns I am only looking for string values of 'Yes' in columns AB and AK and 'No', 'N' or '-' in column BB

 

[ClimoC]

All of the worksheets in the workbook have the same number of columns. Columns A through to BV. I am only interested in 3 columns - AB, AK and BB. In those columns I am only looking for string values of 'Yes' in columns AB and AK and 'No', 'N' or '-' in column BB

Concerning the sheets, do you just have 10 worksheets per book, with no other different sheets?

If not (ie you DO have other sheets in the WB), is there a common naming convention with the Sheets? (e.g. "BudgetJan","BudgetFeb"...etc)

 

[Moire]

Hi

There could be any number of worksheets, and as to the naming convention, the names would be different as they are data dumps from a database. Therefore, the names could be for example AA, BB, BBB, etc