I am working on the attached sheet and I would like to link Sheet 1 to sheet 2.
Sheet 2 is currently broken up into species (column D) and has percentages based on each species code.
However in sheet 1 I would instead like to base the total amounts on the Kennel (column B) for each month and year.
So for example in sheet 1 cell G2 would have a total of all species of dogs within kennel K2 for January 2007 and so on.
Can someone please let me know how I would go about doing so?