Grouping rows so that they stay together during sort/filter

[Fiona Lam]

Hi all

Is it possible to link rows together so that when a sort
or filter is applied the rows are kept together?

Any help would be appreciated :))

Thanks, Fiona.

[CLR]

Hey Fiona......

One thing I do is to add an extra column to my database and do a Series-Fill
on it giving me "line numbers", in order, from top to bottom for the
existing sort, (even tho there might be spaces or whatever
therein).........then, as long as I include that column in the database, no
matter how I sort it I can always return to the original configuration by
simply sorting on THAT column.........hope this helps.....

Vaya con Dios,
Chuck, CABGx3

"Fiona Lam" <fion...@gbst.com> wrote in message
news:d20801c11ae2$e1a284a0$b1e62ecf@tkmsftngxa04...

[Fiona Lam]

Hi, thanks, but it's not going to work for my purposes.
I'm mainly going to be using an AutoFilter on my
spreadsheet, say on the Module or Sub-Module column. I
don't really want to have to fill the blank cells with
redundant data so that the rows are selected when an
autofilter is applied.

eg
Module Sub-Module Test Name Test Step Exp Result
====================================================
Mod1 Sub1 Test1 Step1 Exp1
Step2 Exp2
Step3 Exp3

I also thought of putting the redundant data in, but
making the text "invisible" but then the macro I have
written to extract the data will need fixing (but I will
do that only as a last resort)

Is what I'm wanting possible?

>.
>

[Dave Peterson]

Here's one option.

Populate all your fields. Assume your range is A3:C99. Select it.
Edit|goto|special|Blanks.
type = (equal sign), hit up arrow, hit ctrl-enter. this filled in all the empty
cells with a formula that said =theoneabove.

Copy|paste special values (if you want)

Now select A4:c99 (one row down)

Now use Format|conditional formatting and use a formula (say A4 is the
activecell) =a4=a3.
format white on white (or colors to hide the text).

And now they should look empty.

You can continue to filter.

--

Dave Peterson
ec3...@msn.com