I'm having a hard time with this problem. Please help!
Example:

I need the following to sort:

A1= Green B1= 1 C1=0 D1=1
A2= Blue B2= 5 C2=1 D2=0
A3= Yellow B3= 0 C3=0 D3=0
A4= Red B4= 3 C4=3 D4=0

Since cell A3 Yellow and its values in the row B3, C3 & D3 are zero I
need to replace it with A4 Red... To something likes this:

A1= Green B1= 1 C1=0 D1=1
A2= Blue B2= 5 C2=1 D2=0
A3= Red B3= 3 C3=3 D3=0

Above is just an example of hundreds of these charts. Currently I have
to use the "cut-and paste" method and as you know it's not very
productive. Any advise will be greatly appreciated.

Henry Nguyen