Forum Discussion
Auto increment in different pages
In Excel Online, you can use formulas and referencing techniques to auto increment values across different pages or sheets.
Here is a general approach you can follow:
- Start by setting up your initial page or sheet with the desired layout and data in columns. Let's say you have your technical sheet template in Sheet1.
- In another sheet (e.g., Sheet2), you can reference the data from Sheet1 and automatically increment the values using formulas.
- Enter the formula in cell C8 of Sheet2 to retrieve the value from C8 in Sheet1: =Sheet1!C8
- Copy the formula to the desired range in Sheet2, and the references will automatically adjust. For example, copy the formula from C8 to C9, C10, and so on.
- If you need to increment the column reference as well (e.g., from C8 to D8, E8, etc.), you can use the COLUMN function in combination with the INDIRECT function. For example, if you want to increment the column reference by 1 for each row, you can use the following formula in C8 of Sheet2: =INDIRECT("Sheet1!" & COLUMN()+1 & ROW())
- Copy the formula to the desired range in Sheet2, and both the row and column references will increment accordingly.
*English formula is =Sheet1!C8. In the Spanish version, it would be =Hoja1!C8, where "Hoja1" is the Spanish translation of "Sheet1".
Similarly, if you want to use the formula to increment the column reference, the English formula is =INDIRECT("Sheet1!" & COLUMN()+1 & ROW()). In the Spanish version, it would be =INDIRECT("Hoja1!" & COLUMNA()+1 & FILA()), where "COLUMNA" is the Spanish translation of "COLUMN" and "FILA" is the translation of "ROW".
By using formulas and referencing techniques, you can save time and effort by auto incrementing values across different pages or sheets. Adjust the formulas as needed based on your specific requirements and layout.