How to Copy a row from sheet1 to sheet2 with "if statement"

[francescoorsini]

This below is the Sheet1

[TABLE="class: cms_table_grid, width: 500"]
<tbody>[TR]
[TD]Model[/TD]
[TD]Brand[/TD]
[TD]Status[/TD]
[TD]Quantity[/TD]
[TD]Minimal Quantity[/TD]
[/TR]
[TR]
[TD]a1[/TD]
[TD]Asus[/TD]
[TD]In stock[/TD]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]a2[/TD]
[TD]Sony[/TD]
[TD]In stock[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]a3[/TD]
[TD]Toshiba[/TD]
[TD]Test[/TD]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]a4[/TD]
[TD]Fujitsu[/TD]
[TD]Test[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]


I want to separate in different Sheet according to status.If status=In stock then copy the row and paste it to Sheet2.If status=Test copy the row and paste it to Sheet3.

This below will be Sheet2
[TABLE="class: cms_table_grid, width: 500"]
<tbody>[TR]
[TD]Model[/TD]
[TD]Brand[/TD]
[TD]Status[/TD]
[TD]Quantity[/TD]
[TD]Minimal Quantity[/TD]
[/TR]
[TR]
[TD]a1[/TD]
[TD]Asus[/TD]
[TD]In stock[/TD]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]a2[/TD]
[TD]Sony[/TD]
[TD]In stock[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



This below will be sheet3

[TABLE="class: cms_table_grid, width: 500"]
<tbody>[TR]
[TD]Model[/TD]
[TD]Brand[/TD]
[TD]Status[/TD]
[TD]Quantity[/TD]
[TD]Minimal Quantity[/TD]
[/TR]
[TR]
[TD]a3[/TD]
[TD]Toshiba[/TD]
[TD]Test[/TD]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]a4[/TD]
[TD]Fujitsu[/TD]
[TD]Test[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

 

[MisterProzilla]

Do you want a formula or vba to do that?

 

[francescoorsini]

I want a formula in fact.if it is possible

 

[My Aswer Is This]

This is a duplicate posting:
You posted this same question here:
http://www.mrexcel.com/forum/excel-...w-sheet1-sheet2-if-statement.html#post4653811

 

[francescoorsini]

I am new to the forum.I opened a new thread since for the first I didnt get a reply which would help me

 

[My Aswer Is This]

I understand that. But this is in violation of forum rules. I personally do not believe you can do what you want with just a formula. But I may be wrong.