Please Help. I need to sort Data A-Z not sure if i need to use Macros

[steveyjohn]

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.

[macropod]

Is there a good reason for not having everything on a single sheet (e.g. dates for every day of the year in column A and Employees in Columns B-CC or dates in columns B-NC and Employees in Column A)? Having a separate sheet for every month just makes it unnecessarily hard to work with.