PDA

View Full Version : Inserting Lines in linked worksheets


simbroreb
Oct 31, 2008, 08:05 AM
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
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
Oct 31, 2008, 08:47 AM
Lines are being added within List A so it stays alphabetical

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

simbroreb
Oct 31, 2008, 08:53 AM
Brilliant!! Thank You