 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / December 2005Moving 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. > Hello, > Here is my set up. I have a sheet of data about 35,000 lines in in cloumn [quoted text clipped - 7 lines] > Thanks, > Lime Thanks... But I need a Macro. I posted in the wrong forum. Lime > Try using AutoFilter and do a search on column J for "contains" Jump. You > can copy/paste and delete what you want. [quoted text clipped - 10 lines] > > Thanks, > > Lime Record a macro while you are doing as suggested....  SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > Try using AutoFilter and do a search on column J for "contains" Jump. You > can copy/paste and delete what you want. [quoted text clipped - 10 lines] >> Thanks, >> Lime |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.