Ask Experts Questions for FREE Help !
Ask
    simbroreb's Avatar
    simbroreb Posts: 3, Reputation: 1
    New Member
    		  
    #1

    Oct 31, 2008, 08:05 AM
    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?
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Oct 31, 2008, 08:35 AM

    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.
    simbroreb's Avatar
    simbroreb Posts: 3, Reputation: 1
    New Member
    		  
    #3

    Oct 31, 2008, 08:47 AM

    Lines are being added within List A so it stays alphabetical
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #4

    Oct 31, 2008, 08:50 AM

    Don't do it that way. Add lines to the bottom of the sheet then sort.
    simbroreb's Avatar
    simbroreb Posts: 3, Reputation: 1
    New Member
    		  
    #5

    Oct 31, 2008, 08:53 AM

    Brilliant!! Thank You
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Electrical equipment with coax lines connected backfeeding 40-60 volts through lines? [ 4 Answers ]

Hi I have a question for any electricians. I am a cable technician and do installations for Cable,Internet,& Voice in homes. What I have encountered a lot is electrical back-feed coming through the copper coax lines feeding from vcr's and tv's in the house which are plugged into electrical outlets....

Excel Worksheets [ 1 Answers ]

I have several worksheets in an Excel spreadsheet. Is there a way that I can print a list of the names of each of the worksheets in the spreadsheet?

Worksheets within the same workbook [ 21 Answers ]

Hi, I have many worksheets within the same file, what I really want is to have either a (link / go to option) from sheet1 to other sheets without using hyperlink because I want to send to others. Example: if I click on Apple from Sheet 1, I will go to Sheet2 Sheet1 Sheet2 ...

Protected worksheets [ 3 Answers ]

When you protect a worksheet in excel but unprotect certain cells, why can't you change the format of the cells or insert comments?

View more questions Search