Alright, I can't seem to wrap my head around solving this one so hopefully someone out there can help.
I have groups of tickets in multiple sections.
| Color Group | # of seats | Section |
| Tan | 6 | 300 |
| Tan | 20 | 301 |
| Tan | 20 | 302 |
| Purple | 15 | 201 |
| Purple | 15 | 202 |
Then I also have people buying tickets
| Receipt # | Color Group | Amount of tickets |
| 1 | Tan | 5 |
| 2 | Tan | 4 |
| 3 | Purple | 2 |
I'm trying to figure out how to calculate a running total of remaining tickets and whether or not each receipt can sit together (they have to be able to sit together). So for example Receipt #1 has bought 5 of the 6 tickets in section 300 so I need to reduce 300 to 1 remaining ticket so when I'm assigning Receipt 2 I'll know I don't have enough tickets remaining to sit them in 300 so they'll need to go to 301 and then reduce 301 by 4 tickets. I hope that makes sense!
