asklibreofficehowtocopyindirectfunction.ods (15.9 KB)

Hi,

in attached file you’ll find 3 sheets (Blad3 doesnt matter (empty). In the first sheet ‘Blad1’ in cells A3:D3 I’ve found (after some searching on Youtube ) formulas to copy some cells from sheet 'Ploeg1). NOTE that the aim was to use cell A1 of ‘Blad1’ to make the formulas…

I didn’t succeed to refer to a column in the sheet ‘Ploeg1’ which would have been even more efficient.

But the main question overhere is:

You notice that I’ve dropped down the formulas from a3:d3 to A4:D7 and they do not adapt to the rows in Ploeg1. I know an INDIRECT function ‘indirects’ textes to cell references and therefore I somehow understand that those formulas in A3:D3 do not adapt to the rows…

How can I write my formula differently so that they do. I’ve tried several ways, for instance =INDIRECT("$"&$A$1&").d2 but libreoffice doesn’t read my intentions on that

Furthermore, I would be pleased if it would also be possible to make the rows dynamic/adaptable.

Thanks again for your concerns,