Hello excel experts!
I dig the internet with this super basic question and can't find the answer to the point i find it ridicoulous
There are 2 tables on different sheets, for example:
and
Tell me, please, are there any standard ways to make that when i rearrange rows in the first table, in the second table, the corresponding rows are also rearranged according to first column
perhaps there is some standard functionality for binding a cell to a specific value? some other binding?
or somehow through smart tables?
This surprises me as this looks like a basic functionality that i don't know if it even exists
Thank you in advance!
I dig the internet with this super basic question and can't find the answer to the point i find it ridicoulous
There are 2 tables on different sheets, for example:
aaa | www |
bbb | xxx |
ccc | yyy |
and
aaa | 1 |
bbb | 2 |
ccc | 3 |
Tell me, please, are there any standard ways to make that when i rearrange rows in the first table, in the second table, the corresponding rows are also rearranged according to first column
perhaps there is some standard functionality for binding a cell to a specific value? some other binding?
or somehow through smart tables?
This surprises me as this looks like a basic functionality that i don't know if it even exists
Thank you in advance!