Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Using one Excel list table in multiple worksheets (https://www.askmehelpdesk.com/showthread.php?t=263779)

  • Sep 25, 2008, 06:23 AM
    Lyvonne
    Using one Excel list table in multiple worksheets
    I have a workbook containing 13 worksheets. Sheet 13 contains two list tables. I need to link sheets 1 through 12 to the list tables in sheet 13 so that only one set of lists has to be updated when changes occur.

    Please help me...
  • Sep 25, 2008, 08:34 AM
    JBeaucaire
    1 Attachment(s)

    To have a cell on one sheet display the same information as a cell on another sheet, just include the sheet name in the reference.

    =Sheet1!A1
    =Sheet1!A2

    If you change the sheetnames, change the reference to match. If you named Sheet1 Main, then the reference would be:

    =Main!A1
    ======
    STEP BY STEP
    1. Create your main reference list on one sheet (Sheet 13?)
    2. On the next sheet, highlight the first cell where you want the duplicate list to start and press =
    3. Use the mouse to change sheets and click on the first cell of the reference, the formula should now look my suggestion above
    4. Press ENTER to complete the formula
    5. Now, highlight the first cell again where you just made your formula, then press CTRL-C to copy it
    6. Move down to the next cell and press ENTER; your formula should cause the second item in the list to appear
    7. Keep copying down until you have made all the items from the original reference list appear.
    8. To create the next duplicate sheet, go to the first duplicate sheet and highlight the entire list of duplicate entries, then press CTRL-C to copy them all at once.
    9. Switch to your new sheet and put your mouse in the position for the first item, then press ENTER
    10. Continue ad nauseum
  • Sep 25, 2008, 08:35 AM
    ScottGem

    I suspect you want to use a VLookup to reference these tables. Checkout VLookup in Excel Help.

  • All times are GMT -7. The time now is 02:21 PM.