cricket1001
Member
I have a worksheet (1) that includes DOB, Age, DOH, Years Worked as headings. I have all the data highlighted including the headings then data>filter so that I can sort the info by any heading. I tried to do a sort in the years worked column from Largest to Smallest, but I keep getting an error message saying that I have to make all the merged cells the same size. But there aren't any merged cells. I have hidden rows, which are civilians, so I can sort only the officers. I have another worksheet (2) in the same workbook that has only the officers with their DOB, age, DOH, years worked, and I can do the data>filters and then sort. Can I not do this when I have hidden rows? Is there another way of doing a sort in data>filters where I can choose only officers and then sort by DOH?
Thanks,
Pat
Thanks,
Pat