Thread: Formula to search for a word and put that entire row in a list
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tracy Tracy is offline
external usenet poster
  
Posts: 70
Default Formula to search for a word and put that entire row in a list
I have a column which contains the word "Contracted" and all corresponding
columns have data which I want to put into another worksheet.
I want to creat a function that allows me to search for only the rows which
contain the word Contracted and then formats the adjacent columns data after
that.
I have probably 3000 rows that it will need to search through putting all
the data in the columns one after another.

Tracy
Reply With QuoteReply With Quote