I have a list of 240 accounts. Say in A1-A240. I need to split that equally among my team. My team may go from 6 to 8 people so is it possible to have a popup that asks how many divisions?
I have a list of 240 accounts. Say in A1-A240. I need to split that equally among my team. My team may go from 6 to 8 people so is it possible to have a popup that asks how many divisions?
What do you exactly mean by "Split Rows"? I know what the math means, but what in Excel do you want to do to the rows?
You realize that some Teams may get one more account than others because of the math?
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Maybe?
Please Login or Register to view this content.
Hey sorry, just dividing the rows. splitting 240 into equal parts.
Yes, I know division doesn't always return equal amounts and that is fine, if that is the case then have the remainder roll into the last worksheet.
I think this may be it!
Thank you!
You're welcome. Glad to help out and thanks for the feedback and the reps.
Hey John, how hard would it be to make this split those into separate pages instead of just adding a blank?
Perhaps?
Please Login or Register to view this content.
separate sheets. so each individual has their own sheet to work on
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks