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?