Coded needed to take a row from mater sheet data and copy into other sheets in workbook based on a condition

[AlxFL]

Been hunting the internet trying to figure this out and I give up so hopefully someone can help me out here.
So overview is customer list and trying to break out customers by sales rep into their own sheets in the workbook. Just trying to set something up for a CRM while we are dealing with FAILForce, I mean Salesforce.

So have a master sheet with "all" the customers and want a row of info to be copied to a territory sheet based on the initials of the sales rep.

 

[dmt32]

Hi, welcome to forum
Have a look a solution posted here:Copy rows of data from one sheet to another based on value in a column on the first sheet
#post 2 for a similar requirement to yours & see if does what you want

Follow the guidance provided but you will need to ensure the column you want to filter by in your master sheet (sales rep) does have a field heading.

Hope Helpful

Dave