Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Select rows, then sort
Hi All,
Word2K, single table. My needs are simple, and I've been searching groups for days to find something I can use. We all know that Word moves empty rows to the top if the whole table is sorted. I don't want to populate them with Z's or delete them to prevent this, so here's what I want a macro to do: 1. start selecting rows in Row 2 (Headers in Row 1) 2. stop when first row with empty cell in Col 2 is reached 3. sort alphabetically ascending on Col 2 (text entries) 4. with range still selected, update fields (SEQ nums in Col 1) Right now, users select populated rows with mouse, sort, then update fields with F9, but I want the process automated so user can simply click a custom toolbar button (I know how to set that up). Shouldn't be hard, but my head is reeling. Can anyone help? -- David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Don't sort top two rows? | Excel Discussion (Misc queries) | |||
How to sort by grouped rows | Excel Discussion (Misc queries) | |||
How do I sort rows with hyperlinks? | Excel Discussion (Misc queries) | |||
Unable to select rows in the repeat rows on top option | Excel Discussion (Misc queries) | |||
Select non-consecutive rows | Excel Discussion (Misc queries) |