My first tab is the master page with all the data. Some of this data is old, but i will be adding to it over the next few weeks.

I want to be able to break down the data by the criteria in column A. in column A there is 3 outcomes "FRI", "TESTING" OR "AUDIT". I want to be able to separate each outcome in separate tabs. The tabs relate to the 3 outcomes in column A.

You will see from the image there is other data in column B to H that needs to be copied with the info in column A.

I want to set up a document that automatically moves my data as per the criteria outlined in column A into the correct tab.

Hopefully you can help

Attached Images

	Untitled.jpg (50.4 KB, 25 views)
	Untitled1.jpg (12.7 KB, 25 views)