Hello,

I have a worksheet that has in column B either numbers, the word "Enter", or
it could be empty. If the cell in column B has a number, it will also have a
data in that row (Column A - AH).

I need a macro that will look at column B to see if there is a number in any
of the cells of column b and if so, I need the macro to copy the data in that
row (columns A - AH) and paste just those rows into a new worksheet.

So for instance, let's say I have 10 rows. In column B, rows 6 - 8 have
numbers; row 9 and 10 has the word "Enter"; row 11 and 12 is empty; and row
13 - 15 have numbers. I need to take only those rows that have numbers in
columin B (6-8 and 13-15) and copy the entire row (columns A-AH) and paste
the data into a new worksheet.

Thanks in advance.