How to add or delete rows into a set of rows in 1 worksheet to get same result in an identical set of rows in 2nd worksheet (different row numbers)

  • Hi all - In my workbook I have two worksheets. Let's call them Primary Sheet & 2ndary sheet.


    In each worksheet I have a set of 20 identical rows with the data in each of these rows in the 2ndary sheet derived by pointing to the equivalent cell in the Primary sheet.


    The row numbers for the 20 rows are ***different*** in the two sheets.


    I want to be able to add or delete rows in the primary sheet and have the equivalent row in the 2ndary sheet added or deleted.


    Is there some way to do that? Thanks in advance to all who assist. (Using Excel 2007, Windows 10)