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 "Edwards, Carson", I would like row 2 to get moved to the "Edwards, Carson" sheet row 7
Then if on the "data" sheet, B9 says "Edwards, Carson" I would like row 9 to get moved to the "Edwards, Carson" sheet row 8 (right below the one before). Similarly, if on the "data" sheet, B21 says "Martin, Jules", I would like row 12 to get moved to the "Martin, Jules" sheet row 7
With the help of Mike7952, I have the following:
But this does not work - I think it has to do with line 7.
Any help is appreciated and let me know if I can provide more details.
The spreadsheet is attached.
Jordan
Bookmarks