Okay,

Here is an example...
I have rows A4-A13 numbered 1-10. I manipulate 1-10 according to what I will be handing out to the shop floor and what they will be working on next. Once I am done numbers are not in sequence hence the filtering. I highlight A3 thru to M13 which has various work order numbers, description etc. and once i highlight A13 to M13, I click on data tab, click on "filter" to have drop down tabs over A3 thru M3. I click on the drop down tab under A3 and select "sort smallest to largest". Now normally once I do this numbers 1-10 will be placed in order for only the particular area that i have highlighted. But now when I do this, everything is grabbed on the entire sheet and placed altogether. I have sections on the same sheet that are for different work centers and I was able to do this process to each one. Now I cant. Is this more detailed? Do you know what would cause this???