| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort data
Rune_Daub < wrote:
My excel sheet consists of 15 columns with headings. I have 500 rows of information. Not all fields are filled out. I have formatted 2000 rows to show if an error has occured in the entered data. Shailesh Shah.. wont the currentregion just sort the data until the first empty cell is encountered in column A??? No, I think CurrentRegion will do. If it don't then I still don't understand the layout. CurrentRegion will stop when it finds a whole empty row. Regards, -- Beto Reply: Erase between the dot (inclusive) and the @. Responder: Borra la frase obvia y el punto previo. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort source data sheet while destination shows same data | Excel Worksheet Functions | |||
| data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
| I want to convert word column data to excel row data to sort addre | Excel Discussion (Misc queries) | |||
| data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
| How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) | |||
![Beto[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
