Sorting and Hidden Rows
 

I have a sheet that is sorted. The area a gave it goes to row 215. However,
when you sort the info only goes to 174. So the sorted items are listed
correctly down to the last row and then, the other rows are hidden, and looks
like 174 and then the next row is 215. Is there a way that as we continue to
add rows the sort goes to that row and the very next row is available and
visable?