HI all!

Even though I have used many formulas recently I am very new to excel so excuse me if my question is a bit elementary. I have looked all over this forum but found nothing to fix my problem.

Here goes:

I need to be able to mark certain rows in my first column of my very long database and have only the marked ones move to the second sheet in my workbook. That's it in a nutshell. I put in a blank column in the first sheet and tried putting an "x" or a "^" and then using a search criteria but that didn't seem to work. I don't need the first column copied but I do need the other 14 columns (B-O) copied in rows. So, I have 471 rows of this worksheet and I might have only 3 marked. I need these 3 to show up on sheet 2 right next to each other. I don't even know if this is possible. Also, I don't know if I should use an "x" in the first column or a check mark. I had some trouble putting the check mark right in the cell. Any help is much appreciated!

Austin