i bit confused.....i just want it to sort when something is changed...i dont
want to have to hit a alt f8 plus run.....

"Gord Dibben" wrote:

Yes.

See this google search result for Formula method or VBA method.

http://snipurl.com/1lkb6


Gord Dibben MS Excel MVP

On Tue, 22 May 2007 09:00:00 -0700, loc wrote:

Can you auto sort a group of cells when a value is changed?