parsing data into worksheets
 

Hi,

I have a huge data base with several columns. Each row is a test cas
with a number at the end. How do I go through this database and sor
out specific testcases into two separate worksheets?

i.e
test1.2- ch283
test1.3- ch283
test1.2- ch1175
test1.3- ch1175
test1.2- ch12
test1.3- ch12

how do i get all ch283 and ch12 test cases in one worksheet and al
test cases in ch1175 in another worksheet

--
Message posted from http://www.ExcelForum.com

parsing data into worksheets
 

Hi
use 'Data - Filter - Advanced Filter' for this. See:
http://www.contextures.com/xladvfilter01.html

--
Regards
Frank Kabel
Frankfurt, Germany

"pumba680 " schrieb im
Newsbeitrag ...
Hi,

I have a huge data base with several columns. Each row is a test
case
with a number at the end. How do I go through this database and sort
out specific testcases into two separate worksheets?

i.e
test1.2- ch283
test1.3- ch283
test1.2- ch1175
test1.3- ch1175
test1.2- ch12
test1.3- ch12

how do i get all ch283 and ch12 test cases in one worksheet and all
test cases in ch1175 in another worksheet?


---
Message posted from http://www.ExcelForum.com/