I have a sales tracker that stores all deals on a main sheet. Collumn B is for the Agent name. I then have separate worksheet for each agent. I would like to build a module that would automatically copy over rows containing the agent name in column B to their individual sheets. I can't for the life of me figure out how to do this, even though it seems like a pretty simple thing to do. We do slightly different things with the tallies and functions on the individual agent sheets, so it's not enough to just filter the main sheet by agent. I need it duplicated.
[TABLE="border: 0, cellpadding: 0, cellspacing: 0"]
[TD="width: 21"]A[/TD]
[TD="width: 68"]B[/TD]
[TD="align: right"]1[/TD]
Jamie
[/td]
[TD="align: right"]2[/TD]
Dave
[/td]
[TD="align: right"]3[/TD]
Paul
[/td]
[TD="align: right"]4[/TD]
Jamie
[/td]
[TD="align: right"]5[/TD]
Adam
[/td]
[TD="align: right"]6[/TD]
Adam
[/td]
[TD="align: right"]7[/TD]
Alison
[/td]
[TD="align: right"]8[/TD]
Adam
[/td]
[TD="align: right"]9[/TD]
Jamie
[/td]
[TD="align: right"]10[/TD]
Adam
[/td]
[TD="align: right"]11[/TD]
Paul
[/td]
[TD="align: right"]12[/TD]
Paul
[/td]
[TD="align: right"]13[/TD]
Jamie
[/td]
[TD="align: right"]14[/TD]
Paul
[/td]
[/TABLE]