Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Rows/Columns Automatically
I have a spreadsheet and I want to automatically sort the rows and columns as
new data is entered into blank cells. What is the best way to do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Rows/Columns Automatically
You would have to insert a worksheet_change event into the sheet itself to watch for changes in the key row, but that might get weird since it would sort as soon as you entered that cell's data, and you'd find the row you were editing now in the middle of the data set. Perhaps a less irritating solution would be to record a macro of you sorting the data and put it on a button on your sheet, you can press it to quickly sort the new data when you're DONE entering it. -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=61755 |
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 Several Columns/Rows Automatically | Excel Worksheet Functions | |||
Automatically sorting columns by date | Excel Discussion (Misc queries) | |||
Sorting automatically by columns | Excel Discussion (Misc queries) |