View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kay Kay is offline
external usenet poster
 
Posts: 129
Default macro to find data and filter it and copy to another worksheet

I have a worksheet which has many columns,
what i would like to do that under "Description" column i have such statements
"Suggest resource for "SAP Services Engineer" position on project"
Suggest resource for "Oracle Services Engineer" position on project
So i want to create a macro which will look for "SAP" word in "Description"
column and then filter those rows and copy those rows to other sheet.

Thanks!