Auto Email Generator Excel

Tips and tricks for excel fixtures and league table generator.. I can swear that i have seen behaviours where excel automatically fills in a new, inserted row with the same formula as on the row above. i know this can be done with. Create a dynamic source range. excel is not smart enough to know when you have added values to