nicolas877
New Member
- Joined
- Jan 15, 2022
- Messages
- 13
- Office Version
- 2019
- Platform
- Windows
Hi forum, i came across with this problem. I need to divide certain rows by an input number to assign them to people. Like This
CASE - NAME
777
333
999
993
101
190
to this...(in this will be dividing by 3, to assign 3 people)
CASE - NAME
777 Juan
333 Juan
999 Kate
993 Kate
101 Leon
190 Leon
But the quantity of names can be variable , line 2 names ,3 names, 4 names...so there is a way to divide all the rows by certain input in a msg box an then assign a name to each division ? I only know static division by 2 in the middle with MidRow command. Thank you in advance
CASE - NAME
777
333
999
993
101
190
to this...(in this will be dividing by 3, to assign 3 people)
CASE - NAME
777 Juan
333 Juan
999 Kate
993 Kate
101 Leon
190 Leon
But the quantity of names can be variable , line 2 names ,3 names, 4 names...so there is a way to divide all the rows by certain input in a msg box an then assign a name to each division ? I only know static division by 2 in the middle with MidRow command. Thank you in advance