Faffer
Fish Fanatic
When you think it through, you will realize that yeast is a living organism that is using the sugar to grow and increase its numbers. That means that your mix contains a good source of starter material for the next CO2 bottle. You can seed the second batch by simply using some of the first batch as a starter. Every few batches, you might want to use fresh yeast but you can produce several bottles from a single dose of yeast.
Does that mean you can simply just add sugar every week or will the alcohol kill off the yeast, so you need to dilute it with new water?