Simple move rows to new sheet based on value in column

[MaliyanJ]

I have one sheet with 3 (A:C) columns. Where column C contains the value 'Y' I'd like to move the entire row to compile a new data set in a second sheet. Both sheets have header rows.

Eg. mudmap below

Sheet 1 : how it looks

[/URL][/IMG]



Sheet 2 : How i'd like it to look!

[/URL][/IMG]


Simple formula/ macro? THANKS!

 

[My Aswer Is This]

When you say "Move" do you mean copy row from sheet (1) to sheet(2) if sheet (1) has a "Y" in column "C" and keep the original row in sheet (1) or delete the original row from sheet (1)

Is this a uppercase "Y" of a lowercase "y"

And it would be nice to give me two exact sheet names.