I am trying to set a master schedule of my kids schedules.

On the soccer &/or football schedules we have A for away and H for home.

Sheet 1 is the master schedule of all my kids
Sheet 2 has the soccer schedule

I want sheet 1 to look to see if sheet 2 b6 = contains either "A" or "H" or
see if it is blank. If sheet 2 b6 has "A" or "H" inside copy range of cells
to sheet 1.
If sheet 2 b2 is blank - nothing happens

Can I do this?
--
Kelli