I have to create a workbook containing 8 sheets. The first sheet is the master sheet with a listing of all open files and who is handling the file. The remaining 7 sheets are the names of the people who are handling the file and a breakdown of all the files they currently have according to the master sheet.
I want the user to be able to input data on the master sheet "FR-Directory" and have the data auto populate to the individual sheets according to who is handling the file "Handling File" (Column D) as well as keep it in alphabetical order according to "Surname" (Column A).
I have also added an auto sort feature to the master sheet "FR-Directory" that will sort the data alphabetically once the user has selected a different tab. I wanted the data to sort once saved, but was unable to get that feature to work so for now we will have to remember to activiate the tab by selecting a different tab and then go back....unless someone has a better idea?
I have attached a sample of the file I am currently using.
Any help is greatly appreciated
Bookmarks