Excel sorting help

10-04-2004, 10:57 PM

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.

Cyber Wolf · 10-05-2004, 06:16 AM

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

10-05-2004, 12:34 PM

Quote:

Originally Posted by Cyber Wolf

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.

flippant · 10-06-2004, 04:41 PM

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

Happy Monkey · 10-06-2004, 05:22 PM

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

10-06-2004, 10:39 PM

Quote:

Originally Posted by Happy Monkey

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.

10-04-2004, 10:57 PM	#1
cam2 Guest Posts: n/a	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.

10-05-2004, 06:16 AM	#2
Cyber Wolf As stable as a ring of PU-239 Join Date: Jun 2004 Location: On a huge rock covered in water, highly advanced moss and 7 billion parasites Posts: 1,264	I assume you've tried using the Data > Sort menu item? __________________ "I don't see what's so triffic about creating people as people and then getting' upset 'cos they act like people." ~Adam Young, Good Omens "I don't see why it matters what is written. Not when it's about people. It can always be crossed out." ~Adam Young, Good Omens

10-06-2004, 05:22 PM	#5
Happy Monkey I think this line's mostly filler. Join Date: Jan 2003 Location: DC Posts: 13,575	I've got an annoying way to do it. I tied the macro to data entry. __________________ _________________ \|...............\| We live in the nick of times. \| Len 17, Wid 3 \| \|_______________\| [pics]

10-06-2004, 04:41 PM	#4
flippant shameless....so stop trying so hard....-me Join Date: Sep 2004 Location: Colorado location* Posts: 215	From my experience with excel you are correct......that is impossible.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)