Hi,
I'm trying to get the following done for a subset of my master dataset.
The data has account name, salesrep, revenue, quantity
Sometimes the salesrep is a salesgroup, i.e. assigned to two reps instead of one.
When that happens, I need to manually insert a line, copy the row, then split the revenue and and quantity equally between the original and duplicated row.
Can someone please help me with a vba code that would help me achieve this much faster?
Thank you!
Bookmarks