copy rows from worksheet1 to worksheet2 if certain criteria are met.

Hi,

I wanted to automatically copy rows of from the master worksheet to separate worksheets based on 7P for Noc and 7A for Day. Using a macro.

Please see attached for visual.

Thanks