When I delete the data of a tem member in the team alignment tab and shift the data up the worksheet loses its empty tabs. Also When I go to the corresponding team tab sheet the deleted team member has "ref" in the cell where their name used to be. Over all I need the data in the team alignment to shift upwards when I remove a team member and also I need the names and their corresponding data to shift up on their team tabs simultaneously. Any help would be greatly appreciated as I am mostly a novice, thank you in advance.
Bookmarks