| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Moving a Selection of data???
Try using AutoFilter and do a search on column J for "contains" Jump. You
can copy/paste and delete what you want. "Lime" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Moving a Selection of data???
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" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Moving a Selection of data???
Record a macro while you are doing as suggested....
-- Don Guillett SalesAid Software "Barb Reinhardt" wrote in message ... Try using AutoFilter and do a search on column J for "contains" Jump. You can copy/paste and delete what you want. "Lime" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving Data | Excel Discussion (Misc queries) | |||
| Data selection on line chart | Charts and Charting in Excel | |||
| Macro data selection line delete | Excel Discussion (Misc queries) | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| Data Table - does it work with DDE links and Stock Tickers? | Excel Worksheet Functions | |||
Linear Mode
