Hi,
You could name the location of the data on each sheet with a name
created in a way that makes it easy to figure out the name from the row
number. You can then use the INDIRECT() function to retrieve the
information you want.
For example, on the second sheet, the name of the range could be
Sour
On 19 Sep 2023 at 23:06, Tom Cloyd MS MA wrote:
Date sent: Tue, 19 Sep 2023 23:06:41 -0700
To: LibreOffice User's Help Forum
From: Tom Cloyd MS MA
Subject:[libreoffice-users] Calc: how to
auto-increment sheet names in a
I have trying to solve this problem all evening, with no hint of success:
Let's say I have 11 sheets in a Calc spreadsheet. Sheets 2 to 11 contain
data summarized in cells A1:E1 of each sheet.
I want to capture these summary data in sheet 1, starting with cell
A1:E1. But I then want to copy t