Auto Sort
 

How can I make cells 'A12:P42' sort automatically?

I will have a last name in A12 a first Name in E12 and then number
down to P12.
I want the sort to be by A12 and to keep all of A12 informatio
together just reorganize it in my chart so that when I look at it I ca
see all my client info alphabetically.

Thanx

Please keep explaination clear, simple and baby step easy

--
oberon.blac
-----------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...fo&userid=2673
View this thread: http://www.excelforum.com/showthread.php?threadid=46667

Auto Sort
 

Hi oberon,
You can have you table sorted as soon as you make an entry, but
it will be very difficult for you type into the next cell if the whole
row has moved -- I don't think you want to do that.

Rather than a change event, you might consider a double click
event, or a sheet activation event.
Sorting triggered by an Event Macro (#activate)
Sorting, Some notes on sorting in Excel
http://www.mvps.org/dmcritchie/excel...g.htm#activate

Rather than just give you the answer, you can modify the sort
supplied above by recording a macro to sort your specific range
and use that as your sort enclosed within one of the event macros.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"oberon.black" wrote in message
...

How can I make cells 'A12:P42' sort automatically?

I will have a last name in A12 a first Name in E12 and then numbers
down to P12.
I want the sort to be by A12 and to keep all of A12 information
together just reorganize it in my chart so that when I look at it I can
see all my client info alphabetically.

Thanx

Please keep explaination clear, simple and baby step easy.


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=466674

Auto Sort
 

Thanks for the advice I think I will just scrap that part of the project
then.


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=466674