If you're simply wanting to only see the rows of data with "1" in column A,
you can do that by AutoFilter. The only requirement is that your data have a
row of titles for each column across the top.

1) If they don't have titles, add them.
2) Click on the titles row
3) Select Data Filter AutoFilter to turn it on
4) Select the drop down for column A and choose "1"

You should now be looking at the only the rows you wanted. You could copy
everything at once to Sheet2 now, if you want, since the copy would only take
the visible rows...another benefit of the AutoFilter.

Or, you can just work with the data in place. Once you start using an
AutoFilter you may find the need for a second sheet unnecessary.


--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"Laurelle" wrote:

I'm not sure which function to use. This is what I have:
Sheet #1
- has 9 column
- has 200 rows
- Column A contains numbers from 1 to 9 in no specific order
A B C D E F G H I
1 3 12 15 16 2 6 8 9
3 6 1 5 2 8 7 32 44
5 2 5 9 3 8 6 20 21
1 8 10 17 33 35 40 50 100

- Columns B to I contains numbers

What I want should look like this in Sheet #2 brought in from sheet #1

A B C D E F G H I
1 3 12 15 16 2 6 8 9
1 8 10 17 33 35 40 50 100

Can you let me know how I can accomplish this?

--
Thanks,
Laurelle