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

Hi Kelli,

One way is to use the following for all the cells you can to show (copy) on
sheet1

for example on sheet1 at the area you want:

=if(or('sheet2'!$b$6="H", 'sheet2'!$b$6="A"), 'sheet2'!c3)

where c3 is the cell to show.
--
Hope this helps
Martin Fishlock, www.nyfconsultants.com, Wolverhampton, UK
Please do not forget to rate this reply.


"Kelli Jordan" wrote:

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