solve Sorting problems...

As part of my job, I have to record data in a number of different columns. Everything in columns A-Z in that row is connected in some way. My problem is, when I need to sort things by different factors, it changes only the data in one column and ruins my record. I also need to format things in such a way that my co-workers don't sort the information, in other words, I need to make things idiot proof.

I looking to keep all my data grouped, so all the data doesn't get mixed up. I want to be able to sort by name, date, number and etc. I have two Excel books and just can't find the correct answer.

Thank you..

Hi Gunnett,

Have you tried Autofilter? Sounds like it should do what you want.

Select the range of columns >data >autofilter

Ed

Thanks I about willing to try anything at this point