Breaking down data in separate tabs
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
|