Thread: Extracting Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
leimst leimst is offline
external usenet poster
 
Posts: 34
Default Extracting Data

I have a large spreadsheet and I would like to search 3 of the colums for
certain information. If any of the information is found in any of the 3
columns, I would like to copy and paste that entire row to a new worksheet.
Let's say that I would like to search column C for "National", column G for
"Account" and column L for any entry starting with "Acme" (so maybe
"Acme*"?).

Any help would be appreciated.

Brian