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.

Attached Files

Dynamic Row Reference.xlsx (10.0 KB, 6 views)

P.e. into cell C26 enter the formula
=OFFSET($B26,-10,4)
and copy down until C31.

When the number of rows between top rows of all weekly tables remains same, the formula will work (of-course topmost table must be set up manually).

In C16 enter relative referencing and pull down to C20.
Select B15:F22
- Copy
- Go to the desired place (e.g. B25)
- Paste Special
- Formulas
- OK


FYI OFFSET is a volatile function

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you Arvil, but how about the xlookup in the formula?

Thank you. This is exactly what I am looking for.

You're welcome

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post