Is it possible to link a “range” (I use that word loosely) of cells across sheets?
A simple example is provided below in file abc.ods.
The MainSheet is intended to display the content of each of the three “Part” sheets. The question is how to write the correct formula into the input line of the main sheet (without cancelling out other cells).
The first part sheet, called MainPartA, is easy and works fine by just importing the text data from one cell.
But I dont know how to write the formulas for the second and third sheets.
The second sheet is a list MainPartB.A1:A3. It’s just a column of multiple text cells stacked row by row, but I cant figure out how to get the formula to work right in the MainSheet.
The third sheet is essentially the same question as in the second sheet, except the selection contains multiple columns and multiple rows, e.g. A1:C3.
abc.ods (9.4 KB)
