spliting data (1 Viewer)

[Neo]

In the attched spreadsheet I have a master Tab, where I copy all the data, the type column is the identifer of each row. There are two things I need to do and have no idea how to do it,

1) split the data from the "Master" tab into its repective tabs (based on type) the key here is to split the data from the "master" tab with out adding in blank rows

2) on the "insert" tab be able to select the type and have all the records for that type are placed on this tab, again with out any blank rows.

any help or advice would be great

thanks

 

[neileg]

Try using a pivot table. It won't do exactly what you describe but it may be enough.