select cut and paste

[Pandab2002]

Good afternoon all. I have a spreadsheet that contains trouble ticket info. I need to figure out how to select all the rows that contain certain words. I can figure out the cutting and pasting process, but I have been unable to find a command the looks at column H and selects the entire row for each occurance of the word MAC. After that it's a simple cut and paste to a new worksheet.

 

[SkipVought]

Hi,

Try looking at menu item Data/AutoFilter.

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}

 

[Pandab2002]

Thanks for your advise, but I am trying to automate this process. I get a csv file from my telecom vendor every morning that has ticket info. I am interested in cutting all the rows that contain certain criteria and the pasting them to another worksheet. The autofilter works great if I manually do it. I can't find a way to use it in an automated process.

 

[SkipVought]

It CAN be automated.

Turn on your macro recorder and record what you need to do.

Then post your code, and we'll help you clean it up.

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}