I work in an architecture firm and in belgium we have a standardized document for social housing. I added a screenshot of the problem. When i try to select a row, it selects a row a few rows down.
The rows i'm trying to select are the ones that have been linked to another tab and then have been removed in the other tab.
I tried to click row 117, you can see that excel selects a whole different row.
(also is there a way to delete all rows that have been deleted in another tab?)