I have a spreadsheet with which I wish to split in two (or delete alternate
rows). Imagine banded rows with every second shaded row to be moved into
another worksheet with the unbanded or unshaded rows remaining.

Any suggestions on how to do this?

Thanks in advance.
Nic

--
I don''t Excel at Excel

In Excel2003:
Enter this formula in row 1 in an empty helper column and fill it down as
required:
=MOD(ROW(),2)=0
Apply Autofilter to the helper column and select TRUE as filtering criterium.
Select visible rows and Copy
Paste in a new sheet
Go back to the original sheet
select FALSE as filtering criterium
Select visible rows and Delete rows

Regards,
Stefi


„Nic Zunâ€� ezt Ã*rta:

> I have a spreadsheet with which I wish to split in two (or delete alternate
> rows). Imagine banded rows with every second shaded row to be moved into
> another worksheet with the unbanded or unshaded rows remaining.
>
> Any suggestions on how to do this?
>
> Thanks in advance.
> Nic
>
> --
> I don''t Excel at Excel

Thanks very much Stefi - works well!!

Cheers,

Nic
--
I don''''t Excel at Excel


"Stefi" wrote:

> In Excel2003:
> Enter this formula in row 1 in an empty helper column and fill it down as
> required:
> =MOD(ROW(),2)=0
> Apply Autofilter to the helper column and select TRUE as filtering criterium.
> Select visible rows and Copy
> Paste in a new sheet
> Go back to the original sheet
> select FALSE as filtering criterium
> Select visible rows and Delete rows
>
> Regards,
> Stefi
>
>
> „Nic Zunâ€� ezt Ã*rta:
>
> > I have a spreadsheet with which I wish to split in two (or delete alternate
> > rows). Imagine banded rows with every second shaded row to be moved into
> > another worksheet with the unbanded or unshaded rows remaining.
> >
> > Any suggestions on how to do this?
> >
> > Thanks in advance.
> > Nic
> >
> > --
> > I don''t Excel at Excel

You are welcome! Thanks for the feedback!
Stefi

„Nic Zunâ€� ezt Ã*rta:

> Thanks very much Stefi - works well!!
>
> Cheers,
>
> Nic
> --
> I don''''t Excel at Excel
>
>
> "Stefi" wrote:
>
> > In Excel2003:
> > Enter this formula in row 1 in an empty helper column and fill it down as
> > required:
> > =MOD(ROW(),2)=0
> > Apply Autofilter to the helper column and select TRUE as filtering criterium.
> > Select visible rows and Copy
> > Paste in a new sheet
> > Go back to the original sheet
> > select FALSE as filtering criterium
> > Select visible rows and Delete rows
> >
> > Regards,
> > Stefi
> >
> >
> > „Nic Zunâ€� ezt Ã*rta:
> >
> > > I have a spreadsheet with which I wish to split in two (or delete alternate
> > > rows). Imagine banded rows with every second shaded row to be moved into
> > > another worksheet with the unbanded or unshaded rows remaining.
> > >
> > > Any suggestions on how to do this?
> > >
> > > Thanks in advance.
> > > Nic
> > >
> > > --
> > > I don''t Excel at Excel