How to change the row references in a formula when copied
Hi. I work with a template with a start and end data in separate columns. The end data in the first week is the start data of the second week. Is there a way that when the previous template of the previous week is copied, the row references of the formula of start column are automatically adjusted when copied in the next week?
I have attached a sample for clarity.
Thank you.
|