Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
LIVE
SOLVED

creating inventory tracker; Shareing specific columns on multiple sheets

Copper Contributor

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

 

2 Replies
best response confirmed by Aaron_Ciccarelli (Copper Contributor)
Solution

@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 Thank you so much. this is exactly what i need. Thank you

1 best response

Accepted Solutions
best response confirmed by Aaron_Ciccarelli (Copper Contributor)
Solution

@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.

View solution in original post