I hope I put this in the correct place.
Let's say I have a workbook that contains 2 Worksheets named "Worksheet 1"
and "Worksheet 2"

In "Worksheet 1" I have the following information. In cell A1 = 1, B1 = 2,
C1 = 3 now based on this information anytime that cell B1 = 2 I want to copy
that entire row to "Worksheet 2"

First off is this possbile, second if it is how?

Thanks,
Alan