filter data based on criteria and copy to another sheet

[anbarasi_r]

Hi,

This is what i'm trying to do.

I need a code that filters cells in column N for values "0.25" and "0.5" of sheet 1. If a cell value matches 0.25 (example N5) then the corresponding cells in rows B5, C5 and N5 should be copied to sheet 2.

The code should also Check for column M and Column H in Sheet 1. If column M is not same as column H then again, the corresponding cells in column B, C and M should be copied to next line in sheet 2.

Any help is appreciated.

Thanks

[JPMEXCEL]

Hello, I'm sending you a possible solution to your problem remember building the function before running the macro