i have a table of 6 column
first 3 tables already have data in it in a certain sort i would like to keep
second 3 table which i will put data in
i want if any data i put in column let say 6 matches with any data with column 3 it will put what i wrote in same row number as its in column 1
let say i wrote in row 5 in second table i want it when i done writing it auto sort it to same row as table 1 which is row 2 in green text
hopefully you will understand what i need
first 3 tables already have data in it in a certain sort i would like to keep
second 3 table which i will put data in
i want if any data i put in column let say 6 matches with any data with column 3 it will put what i wrote in same row number as its in column 1
let say i wrote in row 5 in second table i want it when i done writing it auto sort it to same row as table 1 which is row 2 in green text
hopefully you will understand what i need
| No | passport number | English name | Birthdate | No | Passport number | Name | expire date | Name in other language |
| 1 | 20225236 | A | 1997-06-22 | 1 | ||||
| 2 | 20225237 | B | 1997-06-23 | 2 | 20225237 | B | ||
| 3 | 20225238 | C | 1997-06-24 | 3 | ||||
| 4 | 20225239 | D | 1997-06-25 | 4 | ||||
| 5 | 20225240 | E | 1997-06-26 | 5 | 20225237 | B | ||
| 6 | 20225241 | F | 1997-06-27 | 6 | ||||
| 7 | 20225242 | G | 1997-06-28 | 7 | ||||
| 8 | 20225243 | H | 1997-06-29 | 8 | ||||
| 9 | 20225244 | I | 1997-06-30 | 9 | ||||
| 10 | 20225245 | J | 1997-07-01 | 10 | ||||
| 11 | 20225246 | K | 1997-07-02 | 11 |
