I want to write a macro to copy the full row from sheet1 to sheet 2 only if the column C is marked as Y? : I am new to macros and wanted to learn the same.
I want to write a macro to copy the full row from sheet1 to sheet 2 only if the column C is marked as Y.

I have three sheets in a workbook and I want to copy all the rows from all the first three sheets into sheet 4 which has the column 'C' marked as Y.

Please help.

Thanks in advance.