| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
New rows at the end of a worksheet don't sort with the worksheet
I imported a dBase file as an excel worksheet. Editing the worksheet seems
to work normally except when I try to add a new row at the bottom of the existing data. When I sort the worksheet on any column, the new row stays at the bottom. If I insert the new row among the existing rows, it sorts with the rest of the data. I am using MS Office Excel 2003/SP2. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
New rows at the end of a worksheet don't sort with the worksheet
How are you sorting?..........If by macro, then perhaps the range is
hardcoded in and excludes those new rows........... Vaya con Dios, Chuck, CABGx3 "John Bloor" wrote: I imported a dBase file as an excel worksheet. Editing the worksheet seems to work normally except when I try to add a new row at the bottom of the existing data. When I sort the worksheet on any column, the new row stays at the bottom. If I insert the new row among the existing rows, it sorts with the rest of the data. I am using MS Office Excel 2003/SP2. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| Search a worksheet, extract rows using a list from another sheet | Excel Discussion (Misc queries) | |||
| sort according to the colored rows | Excel Discussion (Misc queries) | |||
| Sort with multiple header rows | Excel Discussion (Misc queries) | |||
| Display specific rows from table on other worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
