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.
