copying data based on the condition

[subh_xl]

hi all,
this is my first post and i am new to excel macros.
i have some difficulties please help me to get through it.

in Sheet 1 i have four columns

ID name last_name
1 A B
2 B C
1 A B

what i need in second sheet is data of ID 1 only.
Please let me know the solutions.

Thanks in Advance.

 

[jeremypyle]

Please explain a bit what you mean. What do you want to go into the second sheet?

1 A B?

Or something else?

 

[jeremypyle]

In Sheet2, what do you want to go into each cell?

For example, what result do you want in a1, b1, c1, a2, b2, c2, a3, b3, c3? If you tell me this it will help

 

[subh_xl]

Sorry for not providing the data porperly.

in Sheet 2 i want all athe information of ID1.

Id name last_name
1 A B
1 A B

I hope now i am able to express the problem.

 

[subh_xl]

Sorry for not providing the data porperly.

in Sheet 2 i want all athe information of ID1.

Id name last_name
1 A B
1 A B

I hope now i am able to express the problem