Hi,
I have attached a workbook to illustrate.
I need a macro that will copy the Agent's name (associated with target tick-box) to column A (beginning at certain range and moving down - so that it doesn't over right the same cell every time) if the adjacent cell has a value.
Each time this is used, the tick-boxes, and hence the Agent name, will be a different combination. Also there will be a varying number of "orders".
Ideally I need it to take the names (5 boxes are ticked for example), and evenly paste them next to the orders, and when the are no more orders the pasting stops.
It would look something like this:
Agents Orders
Agent2 1-123
Agent8 1-124
Agent11 1-125
Agent12 1-126
Agent13 1-127
Agent18 1-128
Agent2 1-129
Agent8 1-123
Agent11 1-123
Agent12 1-124
Agent13 1-125
Agent18 1-126
Agent2 1-127
Agent8 1-128
Agent11 1-129
Agent12 1-123
Agent13 1-124
Agent18 1-125
Agent2 1-126
Agent8 1-127
Agent11 1-128
Agent12 1-129
Agent13 1-123
Agent18 1-123
Agent2 1-124
Agent8 1-125
Agent11 1-126
Agent12 1-127
Agent13 1-128
Agent18 1-129
Agent2 1-269
Agent8 1-127
I have experimented with macros and loops, but am still very new to it all.
Any help would be greatly appreciated.
Big thanks in advance!
adtc.
Bookmarks