Macro to Move Entire Row Based on Cell Contents

Hi all,

I have a report to calculate commissions for salespeople. I have raw data and then six sheets, one for each of six salespeople. I'd like to create a macro that will read column B, and based on which salesperson it is, move that entire row to that salesperson's sheet.

For instance, if on the "data" sheet B2 says "Johnson, Ted", I would like row 2 to get moved to the "Johnson" sheet row 7
Then if on the "data" sheet, B9 says "Johnson, Ted", I would like row 9 to get moved to the "Johnson" sheet row 8
Similarly, if on the "data" sheet, B12 says "Martin, Julie", I would like row 12 to get moved to the "Martin" sheet row 7

Any help is appreciated and let me know if I can provide more details.

The spreadsheet is attached.

Jordan

Will these sheets already be created or will code need to create them also?

This will work if they will and if there is a , in column B

Please Login or Register  to view this content.

Do you need the row to clear in your data sheet?

I mean once transfered to the desired sheet to clear the selected row.

Ok try this

Please Login or Register  to view this content.

Maybe this

Please Login or Register  to view this content.

@ mike7952,

There is nothing wrong with that, except maybe adding "Option Explicit"

Option Explicit

Thanks Winon... Yea Somethimes i leave that to the OP.

@alpha608,

Yes it will work... As long as column b has the same format as your example workbook. "Johnson, Ted" with the comma.