holiday form

[k_babb]

Hi i have a holiday form i am trying to design using excel

sheet1 has two columns one for forename and one for surname

sheet2 has all the names from sheet one then all the days from January
sheet3 has all the names from sheet one then all the days from February and so on till December. The idea being that all i need to do is add the names to sheet one and they will appear in all the sheets for each month my question is i want to sort the names in alphabetical order but how can i do this so that if i decide to sort sheet1 in February that the information in january sheet will move with the name thus preserve the data for the holidays taken by an individual in January

 

[k_babb]

anyone help there must be a way of locking rows together

 

[VoG]

Yes there is the event procedure

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
'your code goes here
End Sub

Try recording the code when you manually sort and paste the code here. Presumably you want to sort sheets January to December identically to the sheet that you sort?