The attached sheet has a Master List which will contain all the data and do not want anyone to touch in any way. There will not be a vast amount of rows (100 max).
I want people to use the Timetable sheet (possibly in another workbook). I have used a formula to copy data from rows 2-100. If the original cell is blank I have added an IF formula so if it is blank it will return a blank cell rather than an error formula. If I want to sort data in the Timetable sheet it is ok if I sort Colum A (Date). It sorts all the cells containing data first and all the blanks are after. If however I wanted to sort column F (Surname) A to Z order it puts all the blank cells first and puts those with actual names down the bottom of the 100 row range. Excel obviously applies an alphabetical value to "" which comes before A. Or at least I assume that as Excel sorts numerical values before alpha values and that is why there is no problem when sorting Column A.
I have tried sorting and not showing blanks. It then sorts ok. However, there may be new names added to the master list and if I do this then they are not showing on the Timetable sheet unless someone unhides data in that column and then hides it again. Is there a better way to copy data from Master list so it is all included (even if more is added later) and then be able to sort it without the problem described above?
Bookmarks