Sorting one table will sort another table

%3CLINGO-SUB%20id%3D%22lingo-sub-3441149%22%20slang%3D%22en-US%22%3ESorting%20one%20table%20will%20sort%20another%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3441149%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%221%22%20width%3D%22100%25%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2220%25%22%3ENAME%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%3ESURNAME%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%3ENAME%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%3EHOURS%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2220%25%22%3Ename1%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%3Esur1%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%3Ename1%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%3E1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2220%25%22%3E%3CP%3Ename2%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%3Esur2%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%3Ename2%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%3E2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2220%25%22%3Ename3%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%3Esur3%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%3Ename3%3C%2FTD%3E%3CTD%20width%3D%2220%25%22%3E3%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENAME%20%2B%20SURNAME%20%3D%20Tabel%201%3CBR%20%2F%3ENAME%20%2B%20HOURS%20%3D%20Table%202%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20it%20possible%20to%20connect%20Table%202's%20NAME%20column%20to%20Table%201's%20NAME%20column%2C%20so%20that%20if%20I%20sort%20Table%201%20NAMES%2C%20Table%202%20will%20also%20get%20sorted%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI%20can%20connect%20the%20NAMES%20but%20when%20I%20sort%20Table%201%2C%20the%20HOURS%20of%20Table%202%20does%20not%20sort%20with%20it.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3441149%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3442201%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20one%20table%20will%20sort%20another%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3442201%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1405562%22%20target%3D%22_blank%22%3E%40Dian11%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20doesn't%20sort%20the%20second%20table%20because%20you%20have%20a%20blank%20column%20in%20between%20the%20tables.%20To%20achieve%20this%2C%20insert%20some%20dummy%20text%20in%20C1%20say%20%22Dummy%20Column%22%20then%20select%20C1%20and%20press%20Ctrl%2B1%20to%20open%20the%20Format%20Cells%20window%2C%20then%20under%20Number%20Tab%20go%20to%20Custom%20and%20in%20the%20textbox%20under%20the%20Type%2C%20type%20%3CSTRONG%3E%3B%3B%3B%3C%2FSTRONG%3E%20(three%20semicolons)%20so%20that%20the%20dummy%20text%20in%20C1%20will%20be%20displayed.%20And%20now%20the%20second%20table%20will%20also%20get%20sorted%20along%20with%20the%20first%20table.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3442368%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20one%20table%20will%20sort%20another%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3442368%22%20slang%3D%22en-US%22%3EThe%20two%20tables%20have%20to%20be%20separate.%20I%20should%20be%20able%20to%20put%20table%201%20on%20a%20sheet%2C%20and%20table%202%20on%20different%20sheet.%20Then%20when%20I%20sort%20the%20NAMES%20in%20table%201%2C%20table%202%20on%20a%20different%20sheet%20will%20also%20sort.%3C%2FLINGO-BODY%3E
New Contributor

 

NAMESURNAME NAMEHOURS
name1sur1 name11

name2

sur2 name22
name3sur3 name33

 

NAME + SURNAME = Tabel 1
NAME + HOURS = Table 2

Is it possible to connect Table 2's NAME column to Table 1's NAME column, so that if I sort Table 1 NAMES, Table 2 will also get sorted?

I can connect the NAMES but when I sort Table 1, the HOURS of Table 2 does not sort with it.

2 Replies

@Dian11 

 

It doesn't sort the second table because you have a blank column in between the tables. To achieve this, insert some dummy text in C1 say "Dummy Column" then select C1 and press Ctrl+1 to open the Format Cells window, then under Number Tab go to Custom and in the textbox under the Type, type ;;; (three semicolons) so that the dummy text in C1 will be displayed. And now the second table will also get sorted along with the first table.

The two tables have to be separate. I should be able to put table 1 on a sheet, and table 2 on different sheet. Then when I sort the NAMES in table 1, table 2 on a different sheet will also sort.