How i can search a particular account and cut the entire row and paste in another sheet 2.

[harikrishna]

Hello All,

HOw i can search a particular account (irrestpective of how many times it repeats)and cut the entire row and paste in another sheet 2.
Eg: some cells Sheet 1 of spread sheet contains as
191850
191850
191258
191300
191850
191258

Now the macro should find the account 191850 and cut the entire row and paste in sheet 2, As teh account is repeated 3times all teh tree rows should cut and paste in sheet 2 one belwo to other. Similarly same case with the A/c # 191258.As this account is repeated twice the two rows shold be cut and pasted in sheet in continution to teh earlier account191850.

In Sheet 2 the out put looks as below....
191580
191850
191850
191258
191258

<!-- / message -->

 

[pboltonchina]

Why can't you just do a Sort, is the order that important?