I want to mirror 2 tables in 2 sheets in the same workbook, I tried to link the cells which works fine, but what i want to do is more advanced.
Like when I delete a row in the source table I need the destination table to remove that row as well. and when I add a row in the source table I want that row to be added as well.
The source have employees names and IDs, the destination table have Names and IDs and more columns like work shifts and dates .
so I'm looking more to have a 100% exact mirroring of those tables.
Hope anyone can help
Bookmarks