I have 2 tables. table 1, table 2. Table 1 is top table and primary table. Table 2 is bottom table and secondary table. Both tables have same columns. A-R. These are filtered tables with the drop down arrows in boxes in header row. This is what I would like to do. In my top table I want to put the letter "T" in any cell in the R column. when i do this I want the entire row to be copied in the lower table. In the bottom table when I remove the "T" in R column it moves the entire row back up to the top table. Top table needs to have about 30 rows, while the bottom table needs to have about 15 rows. I will probably never use the last 5 or so rows in each table but want them there just in case. Can anyone help with this.
Bookmarks