Thread: parsing data into worksheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default 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/


Reply With QuoteReply With Quote