Hey guys, I need some help. I've been frying my brain trying to get a formula but all I get is a circular reference. Someone told me to write a macro to do it which I have no clue how to do.
I have the following 6 columns:
1. Column A: Day {Mon..Sun}
2. Column B: Demand [kg]
3. Column C...