In my Excel document, I have two sheets, one with data and another that is referencing the first.

Sheet 1 is structured sort of like this:

```
[Meta data]
Date/time | Temperature
2019-01-01 00.00 | 7,5
2019-01-01 00.01 | 7,4
```

The number of rows in the first sheet will grow over time as you add more data.

Sheet 2 is structured sort of like this:

```
[Meta data of a different kind]
Date/time | Temperature | Change in temperature
Copies first date/time in sheet 1 | Copies first temperature in sheet 1 | Calculation
```

As new data is added to sheet 1, I need to add new rows in sheet 2 as well. The way I do this is by selecting the last row in sheet 2, clicking the right corner and manually dragging the formulas downwards until I have covered all of the data in sheet 1. Since the data in sheet 1 can be very large this method is both cumbersome and time consuming.

Sadly, it's not possible to double-click the right corner to auto-fill the formulas downwards, probably because sheet 2 doesn't know how many rows there are in sheet 1.

Do I have to manually drag the formulas downwards or is there a better alternative?