I am stumped on this problem and would really appreciate some help. I have a list of Quality Controls and Patient Data. I need to separate this data into individual sheets within the workbook using a code. I have attached an example of the list in the "Accession" sheet. Originally, this workbook would only contain this tab with only information in the first three columns. I have added the table on this sheet to show how the data needs to be split. Essentially, the data needs to be split based on the Method Letter that is attached to the end of the long accession numbers, like 1532105R_O. This would be an O method. Some have R's after the accession # but those can be ignored. Only the letters preceded by an underscore denotes the method, and some have multiple methods like 1532105R_O_B_G. Tabs would need to be added with the method type as the name of each sheet. To show how they will need to be split, this workbook already has those tabs made and named appropriately. If a method type is not used in the list, as with the "A" method, then a tab will not need to be made and it can be ignored. If I had a code that could automatically do this for me then it would save a massive amount of time and prevent several human errors. Thank you in advance for the help.


Sorting methods Into indiv sheets.xlsx