If a cell equals amount in column B.

[lawnphysics]

I am trying to do the following. I have no idea how to do this. I am sort of new to excel, and I am not even sure I am asking the question right, or if this can even be done.

1) If a cell equals 111 in column B, row 2, then list Row A:3 through H:3 in a list, on Sheet 2.
2) If a cell equals 222 in column B, row 3, then list Row B:3 through H:4 in a list, on Sheet 3.
3) If a cell equals 333 in column B, row 3, then list Row A:3 through H:3 in a list, on Sheet 4.
4) If a cell equals 444 in column B, row 5, then list Row B:3 through H:4 in a list, on Sheet 5.

Let's Say:


5) If cell equals 111 in column B, row 27, then it would list Row A:3 through H:3 in a list, on Sheet two below # 1, as the data needs to be preserved in a list from previous entry 1).

This goes on or 211 rows.

I want it to keep the Row Data 'as is' when it moves it to the New Sheet.

Thanks!

[macropod]

You want a macro to create and populate as many as 211 worksheets?