Hello in Excel 2000 i have 1 tab that links some info into a 2nd tab. The 2nd tab links about 4 columns from tab 1 and the other columns are not linked. My problem is that when i sort my 1st tab only the data thats linked in the 2nd tab sorts. the cells that have no link to the 1st tab dont move screwing up the sheet. How do i sort the cells in my first tab to sort the whole row in the 2nd tab sort also, not just the linked cells.