Is there a way to cause a blank row inserted when there is a break in the
value of one of the columns the document is sorted on
While it's not *exactly* what you're asking for, you could use the
SubTotal feature in the Data menu to add the rows, but they will
include a label in one column, and a subtotal amount in at least one
other column.
You could then hide the detail rows, then use Select Special to
select only visible cells, and then delete any unwanted labels amp; sub
totals.
Hope this helps.
Rgds,
ScottO
quot;GKW in GAquot; gt; wrote in message
...
| Is there a way to cause a blank row inserted when there is a break
in the
| value of one of the columns the document is sorted on
- Jun 04 Wed 2008 20:44
Skipping line on control break
close
全站熱搜
留言列表
發表留言