Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Columns/Rows Automatically
I have a spreadsheet with columns and rows I wanted to sort automatically
when new data is entered into blank cells. What is the best way to do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Columns/Rows Automatically
Do you want this to happen whenever data is entered or by running a macro after several values are entered? -- mdmackillop ------------------------------------------------------------------------ mdmackillop's Profile: http://www.thecodecage.com/forumz/member.php?userid=113 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=61837 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Columns/Rows Automatically
I would like it to automatically resort whenever data is entered. Is this
possible? "mdmackillop" wrote: Do you want this to happen whenever data is entered or by running a macro after several values are entered? -- mdmackillop ------------------------------------------------------------------------ mdmackillop's Profile: http://www.thecodecage.com/forumz/member.php?userid=113 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=61837 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Columns/Rows Automatically
It is possible but I do not recommend it.
If you type in the wrong data and hit Enter, the sort happens and it may be difficult to find the incorrect data. Best to do the sort after you have confirmed that all recent entries are correct. But to assist if you do want to autosort.................. See this google search result for Sandy Mann code to autosort. http://tinyurl.com/39p64f Gord Dibben MS Excel MVP On Tue, 10 Feb 2009 11:45:03 -0800, BG wrote: I would like it to automatically resort whenever data is entered. Is this possible? "mdmackillop" wrote: Do you want this to happen whenever data is entered or by running a macro after several values are entered? -- mdmackillop ------------------------------------------------------------------------ mdmackillop's Profile: http://www.thecodecage.com/forumz/member.php?userid=113 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=61837 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Columns/Rows Automatically
Hello,
If you can live with a second sheet which will be sorted automatically: http://www.sulprobil.com/html/sorting.html This also avoids havoc in case you enter wrong data, I guess. Regards, Bernd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Rows/Columns Automatically | Excel Worksheet Functions | |||
Sorting Rows/Columns Automatically | Excel Worksheet Functions | |||
Sorting Rows/Columns Automatically | Excel Worksheet Functions | |||
Sorting Rows/Columns Automatically | Excel Worksheet Functions | |||
Sorting Several Columns/Rows Automatically | Excel Worksheet Functions |