Hello! In my office, we get a report from a website that comes to us in an Excel spreadsheet. We are looking to run a macro to split that data that is on that sheet into multiple sheets. I will attach a copy of the sheet to this thread. I am looking at grabbing all the information from the persons name to the next persons name. For instance, in the spreadsheet the persons name is John Doe. I want to grab that name and all the information below it until you hit the next persons name, which then I want to take it and paste it into another sheet in the same workbook. The only thing is that each report does not have the same names on it. The only thing that each report has in common is the ============= ============= in column B. Please let me know if there is something that can be done. Thank you!Name_Macro.xlsx