If a Row contains data in Column B, copy entire row to Sheet 2

[coach_z]

What I am trying to do is figure out a formula or vba script to copy a row of information into a new sheet within the same file.
I only want this row to be copied over when there is data (of any sort) in column B of that row.

All done in excel 2007.

 

[SteveO59L]

Why not just filter on col B, the copy & paste?

 

[coach_z]

because that would be too easy!!!! lol.
thank you.

the only issue could be where there are 50+ different entries in that box and selecting all of them would be a bit of a pain.