Index and Hlookup (I think)

[Alteran]

I am looking for a way which I can take a main sheet of records with 5 different types and break them out into five sheets by type automatically as the data is populated in the main sheet

For example my types are CC, DRF, CP, DRC and DRCP

I have my Main sheet, and one sheet representing each type.

To move the information from the main sheet into the individual sheets I would like to use functions that I could just carry down that would pull the rows/records that match the data type, is there a simple way to accomplish this?

 

[MrKowz]

What error are you getting on that line?

Also, another idea would be to create a pivot table, set column B as the page field, and place whatever other data you want to show/summarize in the row/colum/data fields.