List items according to an attribute

[cicco_71]

Dear Mr. and Mrs. Excels,

I'm looking for a solution for the following problem:

I have a huge list (28 000 rows) of items (practically document subchapter titles) that are connected to their parent items (main chapters) as follows:

Chapter title	Subchapter title	Staring page no.
1.1 Cooking fish	1.1.1 Bass	5
1.1 Cooking fish	1.1.2 Salmon	12
1.1 Cooking fish	1.1.3 Catfish	50
1.1 Cooking fish	1.1.4 Hake	61
1.2 Steaming fish	1.2.1 Trout	75
1.2 Steaming fish	1.2.2 Salmon	32
and so on...

I need to make a function (I guess VBA?) that takes "1.1 Cooking fish" as input (for example in cell A1) and fills the range A2:B999 with the corresponding subchapters and their page numbers.

How do I start?...

Thank you very much!

 

[Fluff]

Try it like

      For i = 0 To .Count - 1
         Sheets("Template").Copy , Sheets(Sheets.Count)
         ActiveSheet.Name = .items()(i)
         Ws.Range("A1").AutoFilter 1, .keys()(i)
         Ws.AutoFilter.Range.Columns("B:C").Copy Range("B11")
      Next i