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

[francescoorsini]

This below is the Sheet1

Model	Brand	Status	Quantity	Minimal Quantity
a1	Asus	In stock	2	1
a2	Sony	In stock	1	1
a3	Toshiba	Test	3	1
a4	Fujitsu	Test	1	1

<tbody>
</tbody>

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

Model	Brand	Status	Quantity	Minimal Quantity
a1	Asus	In stock	2	1
a2	Sony	In stock	1	1

<tbody>
</tbody>

This below will be sheet3

Model	Brand	Status	Quantity	Minimal Quantity
a3	Toshiba	Test	3	1
a4	Fujitsu	Test	1	1

<tbody>
</tbody>

 

[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.