| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
sort only rows with data
Mike you are correct, but I should have mentioned that the 'zeros' were
the result of a direct reference to column 'AR' in the corresponding row. I must restablish the reference (i.e. =AR11, AR12, AR13 ...) the corresponding row. Are you saying that Column V and Column AR are showing the same information? Or did you mean that Column V has a formula in it and in that formula somewhere is a reference to Column AR for the same row? In other words, for Row 11, do you really have the formula =AR11 or is the formula more involved than that? If you really have = AR11, then Ryan's code should work for you; otherwise a more involved routine will probably be needed. -- Rick (MVP - Excel) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort data in rows to column | Excel Discussion (Misc queries) | |||
| sort only rows with data | Excel Programming | |||
| Sort data with blank rows dividing data | Excel Discussion (Misc queries) | |||
| Sort with blank rows between data rows | Excel Discussion (Misc queries) | |||
| How to sort data from rows into columns? | Excel Discussion (Misc queries) | |||
Threaded Mode
