Macro to Copy data from Input sheet to Output sheet based out few criteria

[SamT]

Edited to read

I have looked at several of your threads and you are not using CODE Tags.