Forum Discussion

Marques_960's avatar
Marques_960
Copper Contributor
Jun 06, 2023

Auto increment in different pages

Hi everyone I want that somebody could help me solve that problem.

I am making a check list of material in my company and I want to creat a technical sheet for  all material/machinery, but is like 1000 so it will give me a lof of work and time, so I'm asking here if anyone know a way to bypass that situacion, like making a autoincrement for the next pages that a create changing the colunm, changing c8 to c9 and next...

I go put the pictures here

 

I forgot to say but need to be in excel online

I appreciate that somebody could help me :)))

 

 

Excel for web

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Jun 07, 2023

    Marques_960 

    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:

    1. 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.
    2. In another sheet (e.g., Sheet2), you can reference the data from Sheet1 and automatically increment the values using formulas.
    3. Enter the formula in cell C8 of Sheet2 to retrieve the value from C8 in Sheet1: =Sheet1!C8
    4. 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.
    5. 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())
    6. 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.

Resources