L
Laurelle
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?
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?