Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting dataset automatically after entering data in a row [or cel
If I have a spreadsheet with four column, and rows starting at row 2 [headings are in row 1], and increasing daily. One of the columns is a "priority" column, which is 1 [for the highest] down to 5 [for lowest]. I'd like to sort the data each time a new row is entered, such that the highest priorities are listed first. Is there a way for this to happen automatically? Or would I have to, at the least, create a Macro and put that button on the toolbar to press when I want a sort to take place? Any help would be greatly appreciated. Thanks. m [I apologize that this accidentally went in the FrontPage forum as well... sorry about that]. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update data automatically among worksheets | Excel Discussion (Misc queries) | |||
Sorting Data that feeds into other formulas.... | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Sorting data automatically | Excel Worksheet Functions | |||
Sorting Data Automatically | Excel Discussion (Misc queries) |