S
smonczka
At the end of every week I get a report from Peachtree that shows sales
commissions by sales rep. Sales sometimes have two reps involved.
Unfortunately Peachtree only has one field to track a sales rep. So
many line items in the report have one cell with two reps names in it,
like this Rep1/Rep2 or JamesJ/TinaS.
For reporting purposes I need to separate the reps names into separate
cells, so JamesJ/TinaS becomes a cell with JamesJ in one cell and TinaS
in another.
Is it possible to write code that would split out anything before and
after the "/" into two other cells?
Thanks in advance for the help, it's greatly appreciated.
Steve M.
(e-mail address removed)
commissions by sales rep. Sales sometimes have two reps involved.
Unfortunately Peachtree only has one field to track a sales rep. So
many line items in the report have one cell with two reps names in it,
like this Rep1/Rep2 or JamesJ/TinaS.
For reporting purposes I need to separate the reps names into separate
cells, so JamesJ/TinaS becomes a cell with JamesJ in one cell and TinaS
in another.
Is it possible to write code that would split out anything before and
after the "/" into two other cells?
Thanks in advance for the help, it's greatly appreciated.
Steve M.
(e-mail address removed)