Filtering Results and Copying Each Result to a Seperate Sheet

Hi,

I've managed to get so far with my spreadsheet with the help of this forum and wondering if anyone will be able to help me elaborate on what i already have? Basically what I have already is a sheet with a bunch of companies with a checklist next to it and when these boxes are checked and the compile button is pressed the chosen lines then get copied over to the next sheet. This works fine so no problems there but what i am looking to do now is having a button on the sheet with the results which will then filter all of the results by manager name and then copy each result to it's own page including the headers and the entire row belonging to that result. I'm not entirely sure if it's possible but that may be down to my own inexperience. I've attached the sheet below, if anyone could help it would be much appreciated.

Cheers,

Gareth

RedXtest12.xls

Pretty easily doable. Which is the sheet which needs to be branched out manager wise? Is it Customer_List?

You can use this code -

Please Login or Register  to view this content.