3 Formulas drag down

**AlbertLind** · 04-19-2021, 04:22 AM

Hello,

I am new here and I hope someone could help me.

I have a tab called Data with a Data input table and a tab called "BS" with Formulas in in the first 3 rows. These Formulas are related to the first row from the Data table. So,with each line in the Data table it can be created 3 Bookings, thats why I have 3 lines with Formulas which are related to the first row.

No when I want to drag down the 3 lines with the Formuals, the next 3 formulas are not realted to the line 2 but to 5,6 and 7.

Can someone help me to solve this problem?

Thanks in advance.

**JeteMc** · 04-21-2021, 10:16 PM

Hello AlbertLind and Welcome to Excel Forum.
I set up a column (K) to keep up with the row in the Lohnbuch_Eingabemaske table from which the data should be obtained.
Column K is populated using: =ROUNDUP(ROWS(A$1:A1)/3,0)
Cell A2 is populated using:

Formula:

Please Login or Register  to view this content.

As the formula in cell A3 doesn't reference the Lohnbuch_Eingabemaske table it is not changed.
Cell A4 is populated using:

Formula:

Please Login or Register  to view this content.

When cells A2:A4 are selected and the fill handle is dragged down to cell A7 the formulas in A5 and A7 reference the second row of the Lohnbuch_Eingabemaske table.
Let us know if you have any questions.