Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Inserting Lines in linked worksheets (https://www.askmehelpdesk.com/showthread.php?t=275644)

  • Oct 31, 2008, 08:05 AM
    simbroreb
    Inserting Lines in linked worksheets
    I have 3 worksheets (personnel lists with extensions): List A, List B, and List A&B merged. Worksheet 3 cells are linked to the other worksheets as opposed to entering the data.
    My goal was that changes made to sheet A or B would automatically be made to the merged sheet A&B.
    This works perfectly when data is deleted or changed in sheet A or B, but if a line is added to sheet A or B it is not added in the merged sheet.

    Is there a way for this to work or am I approaching it wrong?
  • Oct 31, 2008, 08:35 AM
    ScottGem

    Are you appeneding lines at the bottom? If so, you need to extend the formulas in Sheet 3 to below the current rows. Inserting rows in one sheet doesn't automatically carry through.
  • Oct 31, 2008, 08:47 AM
    simbroreb

    Lines are being added within List A so it stays alphabetical
  • Oct 31, 2008, 08:50 AM
    ScottGem

    Don't do it that way. Add lines to the bottom of the sheet then sort.
  • Oct 31, 2008, 08:53 AM
    simbroreb

    Brilliant!! Thank You

  • All times are GMT -7. The time now is 11:34 AM.