Worksheets within Excel files are linked via the ID values on each tab. All Device and Data tabs must contain the same amount and equal ID values, and no duplicate ID’s must exist on a single tab. Typically, the row or column number is used as the ID.
ID per row:
The formula below may be used to generate the ID in a ID column.
ID per column:
The formula below may be used to generate the ID in a ID row.