Moving a Selection of data???

Hello,
Here is my set up. I have a sheet of data about 35,000 lines in in cloumn
"J" I would like to search for the text "Jump" in the entire column and when
I find it I want to copy that whole row of data along with the Heading &
format of the data sheet to a new sheet and name the sheet "Cause" and then
delete those rows from the data sheet.

Thanks,
Lime

Try using AutoFilter and do a search on column J for "contains" Jump. You
can copy/paste and delete what you want.

"Lime" <[email protected]> wrote in message
news:[email protected]...
> Hello,
> Here is my set up. I have a sheet of data about 35,000 lines in in cloumn
> "J" I would like to search for the text "Jump" in the entire column and
> when
> I find it I want to copy that whole row of data along with the Heading &
> format of the data sheet to a new sheet and name the sheet "Cause" and
> then
> delete those rows from the data sheet.
>
> Thanks,
> Lime

Thanks... But I need a Macro. I posted in the wrong forum.

Lime

"Barb Reinhardt" wrote:

> Try using AutoFilter and do a search on column J for "contains" Jump. You
> can copy/paste and delete what you want.
>
> "Lime" <[email protected]> wrote in message
> news:[email protected]...
> > Hello,
> > Here is my set up. I have a sheet of data about 35,000 lines in in cloumn
> > "J" I would like to search for the text "Jump" in the entire column and
> > when
> > I find it I want to copy that whole row of data along with the Heading &
> > format of the data sheet to a new sheet and name the sheet "Cause" and
> > then
> > delete those rows from the data sheet.
> >
> > Thanks,
> > Lime
>
>
>

Record a macro while you are doing as suggested....

--
Don Guillett
SalesAid Software
[email protected]
"Barb Reinhardt" <[email protected]> wrote in message
news:[email protected]...
> Try using AutoFilter and do a search on column J for "contains" Jump. You
> can copy/paste and delete what you want.
>
> "Lime" <[email protected]> wrote in message
> news:[email protected]...
>> Hello,
>> Here is my set up. I have a sheet of data about 35,000 lines in in cloumn
>> "J" I would like to search for the text "Jump" in the entire column and
>> when
>> I find it I want to copy that whole row of data along with the Heading &
>> format of the data sheet to a new sheet and name the sheet "Cause" and
>> then
>> delete those rows from the data sheet.
>>
>> Thanks,
>> Lime
>
>