Excel sorting help

I've used Excel's help feature and am assuming their is no easier way to set this up, but does anyone know an easy way to automatically sort data throughout an entire Excel sheet after you make changes to a single cell. I need to sort the same data across multiple sheets by different columns(hopefully someone understands what I just said.) I have a macro written that does it but would like to know if there was an easier way.

I assume you've tried using the Data > Sort menu item?

Cyber Wolf wrote:

I assume you've tried using the Data > Sort menu item?

Yeah, but I'm that doesn't sort data unless you go into that menu, I was looking to do a sort after a user had entered data into the worksheet, without any user action. I don't think it's possible though, I'm just sticking with my macro.

From my experience with excel you are correct......that is impossible.

I've got an annoying way to do it. I tied the macro to data entry.

Happy Monkey wrote:

I've got an annoying way to do it. I tied the macro to data entry.

hmm interesting Idea, I'll have to look into that. Thanks everyone, just making sure I hadn't missed something stupidly easy.