is it possible to auto add a blank row based on criteria in 3 adjacent
columns? the data is sorted based on these 3 columns, but we don't need
subtotals, just blank rows. Thank you.

I'd add an extra column and concatenate those 3 fields.

=a2&"..."&b2&"..."&c2
And drag done

Then use that column when I do data|subtotal.

If I didn't want the subtotals, I'd use count (it's always useful <bg). Or
just use the outlining symbols on the left, hide the details and clear the
contents of the subtotal rows.

You may want to hide the details
select the range to clear
Hit F5 (edit|goto or ctrl-g)
Special|visible cells only
then clear those visible cells.

(Especially with xl2007.)

LisaK wrote:

is it possible to auto add a blank row based on criteria in 3 adjacent
columns? the data is sorted based on these 3 columns, but we don't need
subtotals, just blank rows. Thank you.

--

Dave Peterson

Your subject reads add blank columns.

Your description reads blank row.

Which do you want and what are the 3 criteria?

From your description I'm not clear on your layout.

VBA is required to add a blank row or column.


Gord Dibben MS Excel MVP

On Wed, 9 Sep 2009 12:44:36 -0700, LisaK
wrote:

is it possible to auto add a blank row based on criteria in 3 adjacent
columns? the data is sorted based on these 3 columns, but we don't need
subtotals, just blank rows. Thank you.