Forum Discussion

Aaron_Ciccarelli's avatar
Aaron_Ciccarelli
Copper Contributor
Sep 25, 2023
Solved

creating inventory tracker; Shareing specific columns on multiple sheets

Hi all , been a while since i have used Excel let alone a computer. I still remember basic formulas. I am trying to build an inventory tracker. I want certain columns from one sheet to show on 2nd sheet in the book and update when I enter data in the first sheet. IE Sheet 1 columns A-C and F-H to show on sheet 2 columns A-F

 

  • Aaron_Ciccarelli 

    To create an inventory tracker in Excel where specific columns from one sheet (Sheet1) are displayed on another sheet (Sheet2) and update automatically when you enter data in the first sheet, you can use formulas or cell linking. Here is a step-by-step guide for both methods:

    Method 1: Using Formulas

    Sheet1: Enter your inventory data in columns A, B, C, F, G, and H.

    Sheet2: In Sheet2, you can simply reference the cells from Sheet1 that you want to display. For example, if you want to show data from Sheet1 columns A-C and F-H in columns A-F of Sheet2, enter the following formulas in Sheet2:

    • In cell A1 of Sheet2, enter the formula: =Sheet1!A1
    • In cell B1 of Sheet2, enter the formula: =Sheet1!B1
    • In cell C1 of Sheet2, enter the formula: =Sheet1!C1
    • In cell D1 of Sheet2, enter the formula: =Sheet1!F1
    • In cell E1 of Sheet2, enter the formula: =Sheet1!G1
    • In cell F1 of Sheet2, enter the formula: =Sheet1!H1

    After entering these formulas in the respective cells, drag the fill handle (a small square at the bottom-right corner of the cell) down to copy the formulas for as many rows as needed.

    Now, when you enter or update data in Sheet1, it will automatically be reflected in Sheet2.

    Method 2: Using Cell Linking

    Sheet1: Enter your inventory data in columns A, B, C, F, G, and H.

    Sheet2: In this method, you will directly link cells from Sheet1 to Sheet2.

    1. Select cell A1 in Sheet2.
    2. Type = in the formula bar.
    3. Click on cell A1 in Sheet1 (the cell you want to link).
    4. Press Enter.
    • Repeat this process for each cell you want to link from Sheet1 to Sheet2 (e.g., A1, B1, C1, F1, G1, H1).

    After linking the cells, the data in Sheet2 will always mirror the data in Sheet1. Any changes you make in Sheet1 will be immediately reflected in Sheet2.

     

    Choose the method that suits your preference, and you will have a functional inventory tracker with specific columns displayed and updated on the second sheet in your Excel workbook.

    The text and steps were edited with the help of AI.

     

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

    Was the answer useful? Mark them as helpful and like it!

    This will help all forum participants.

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    Aaron_Ciccarelli 

    To create an inventory tracker in Excel where specific columns from one sheet (Sheet1) are displayed on another sheet (Sheet2) and update automatically when you enter data in the first sheet, you can use formulas or cell linking. Here is a step-by-step guide for both methods:

    Method 1: Using Formulas

    Sheet1: Enter your inventory data in columns A, B, C, F, G, and H.

    Sheet2: In Sheet2, you can simply reference the cells from Sheet1 that you want to display. For example, if you want to show data from Sheet1 columns A-C and F-H in columns A-F of Sheet2, enter the following formulas in Sheet2:

    • In cell A1 of Sheet2, enter the formula: =Sheet1!A1
    • In cell B1 of Sheet2, enter the formula: =Sheet1!B1
    • In cell C1 of Sheet2, enter the formula: =Sheet1!C1
    • In cell D1 of Sheet2, enter the formula: =Sheet1!F1
    • In cell E1 of Sheet2, enter the formula: =Sheet1!G1
    • In cell F1 of Sheet2, enter the formula: =Sheet1!H1

    After entering these formulas in the respective cells, drag the fill handle (a small square at the bottom-right corner of the cell) down to copy the formulas for as many rows as needed.

    Now, when you enter or update data in Sheet1, it will automatically be reflected in Sheet2.

    Method 2: Using Cell Linking

    Sheet1: Enter your inventory data in columns A, B, C, F, G, and H.

    Sheet2: In this method, you will directly link cells from Sheet1 to Sheet2.

    1. Select cell A1 in Sheet2.
    2. Type = in the formula bar.
    3. Click on cell A1 in Sheet1 (the cell you want to link).
    4. Press Enter.
    • Repeat this process for each cell you want to link from Sheet1 to Sheet2 (e.g., A1, B1, C1, F1, G1, H1).

    After linking the cells, the data in Sheet2 will always mirror the data in Sheet1. Any changes you make in Sheet1 will be immediately reflected in Sheet2.

     

    Choose the method that suits your preference, and you will have a functional inventory tracker with specific columns displayed and updated on the second sheet in your Excel workbook.

    The text and steps were edited with the help of AI.

     

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

    Was the answer useful? Mark them as helpful and like it!

    This will help all forum participants.

Resources