View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pumba680 pumba680 is offline
external usenet poster
 
Posts: 1
Default 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