Sir, I have 2 worksheets with data table in both sheets. The only first column of table in in both worksheets are having names and are linked and the worksheet 1 is the primary worksheet. That is if I edit/add a name in the worksheet 1, that will also reflect in woksheet 2. Now when I sort the table in worksheet 1 based on first coloumn, the excel asks whether the selection is to be expanded and when cliked yes the whole table will be sorted based on first coloumn. But as the name coloumn of worksheet 2 is functionally linked to worksheet 1 , it also gets sorted with out expanding selection to other coloumns of worksheet 2. Please suggest how to expand the selection to whole table in the worksheet 2 so that relative information in other coloumns also gets sorted based on the first coloumn.