Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a section sort automatically?
I want a section to sort itself automatically when the information is updated
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a section sort automatically?
If the section is A1 thru C10 (no headers), then enter the following in
worksheet code: Sub Worksheet_Change(ByVal Target As Excel.Range) If Intersect(Range("A1:C10"), Target) Is Nothing Then Exit Sub Application.EnableEvents = False Range("A1:C10").Sort Key1:=Range("A1") Application.EnableEvents = True End Sub This will cause automatic re-sort (using column A as the key) after the data has been updated. -- Gary''s Student "Wicus" wrote: I want a section to sort itself automatically when the information is updated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I make Excel sort and graph a list of numbers? | Charts and Charting in Excel | |||
How do I make the sort default to 'No header rows' | Excel Discussion (Misc queries) | |||
make a cell automatically populate with "1" when specified cell va | Excel Discussion (Misc queries) | |||
How can I make cell data automatically shift up when deleting | Excel Discussion (Misc queries) | |||
How can I make cell data automatically shift up when deleting... | Excel Worksheet Functions |