You absorb only what your body needs
With water-soluble vitamins like C and most B vitamins, your body takes what it can use and flushes the rest out in urine. If you are not actually short on a nutrient, the extra dose mostly leaves your body within hours — so the pill empties your wallet, not a real gap.
