This may be very simple..not sure.I need to grab three values from a table
and based on those values, create a fourth value in a second table on another
worksheet.

Eg - I have a column named Dog, one named Colour and one marked State.
So I could have a Poodle, Blue, Pregnant and I could have Spaniel, Red,
Spayed. I need to add how many of each I have and display it on a second
table...so I might have five Blue Poodles who are Pregnant...or two Red
Spaniels that are spayed ....thus the figures I want to return are 5 in the
Pregnant Blue Poodle column and 2 in the Spayed Red Spaniel column.

Any help would be appreciated - my coding skils are minimal..so be gentle.