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)