Hi Guys,

I have created a holidays management spreadsheet for staff. 80 people in total. I have used 13 sheets. 12 for months ( Jan - Dec) and 1 for Data entry sheet. Data entry sheet to be used to enter employee name, start date end etc. However if there is a new starter when I add new employee in the list of names in Data entry sheet the name stays in the bottom, however if i sort it it a-z the name changes in all the sheets but it doesn't change the information in all the months.

Every person have different days booked.

I want to sort names A-Z in Data entry sheet and to automatically affect all the other sheets to update all the information for that specific name.

Sorry guys tried to be as clear as possible.


I have created a simple sample. When I add new name in data entry sheet and alphabetically sort it , it sorts all the names in data entry sheet and Jan sheet but doesn't change the information inputed against names in Jan sheet.

Attached Files

sample.xlsx (12.0 KB, 11 views)