I have a spreadsheet of employee names. I am using =IMPORTRANGE() to import the names into another spreadsheet that tracks expenses in rows next each of the imported employee names.
The problem is when someone adds another name to the first spreadsheet and sorts it alphabetically, the order of names in the second spreadsheet (imported using =IMPORTRANGE()) changes to reflect the change in the first spreadsheet.
Unfortunately the data in the rows associated with the names in the second spreadsheet does not move as well. These stay static so John's name ends up being associated with Ted's data.
I'd like to be able to 'attach' the other data in the rows in the second spreadsheet to the name so that when the names change row, all data in the associated row move with the name.
Is this possible?