Learning Excel
Board Regular
- Joined
- Jul 27, 2002
- Messages
- 99
Hi,
I have a database that has 12000 rows and 22 columns of information
I would like to search for a term in Column F (say Information Technology) and copy the rows that matches the term in a new sheet on the same workbook.
I cannot use filter because the information in Column F can be :
Specialist, Information Technology
Information Technology Group
Application Development Information Technology Division etc
Other terms that I would like to search separately are :
Systems Network
Technical Technology
That is, one sheet of extracted data for Information Technology,Systems Network,Technical Technology.
Appreciate help on this
Learning Excel
I have a database that has 12000 rows and 22 columns of information
I would like to search for a term in Column F (say Information Technology) and copy the rows that matches the term in a new sheet on the same workbook.
I cannot use filter because the information in Column F can be :
Specialist, Information Technology
Information Technology Group
Application Development Information Technology Division etc
Other terms that I would like to search separately are :
Systems Network
Technical Technology
That is, one sheet of extracted data for Information Technology,Systems Network,Technical Technology.
Appreciate help on this
Learning Excel