Forum Discussion
Sorting one table will sort another table
NAME SURNAME NAME HOURS name1 sur1 name1 1 name2 sur2 name2 2 name3 sur3 name3 3 NAME + SURNAME = Tabel 1 NAME + HOURS = Table 2 Is it possible to ...
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.