Tech Support Guy banner
Status
Not open for further replies.
1 - 18 of 18 Posts

·
Registered
Joined
·
28 Posts
Discussion Starter · #1 ·
Hi I need some help.
I have a spreadsheet that i get every day. I need to divide it between a certain number of people each day. So I need a macro to ask me how many people to divide the spreadsheet into separate tabs and then count the rows and paste the data into each spreadsheet. The data is dynamic and the number of people is dynamic. So, if my data is 501 rows, i have 5 people to give the data to, the data will be pasted into 5 separate tabs at 100 for 4 people and 101 rows for the 5th person. thank you for your help.
 

·
Registered
Joined
·
28 Posts
Discussion Starter · #3 ·
Thanks for replying. I have attached a sample report and instructions of what i need in Sheet1 and Sheet2 of the workbook. I thought about what i need and changed it a little bit. Instead of separating the rows into separate sheets, add a column to the left and add in names. Thank you.
 

Attachments

·
Registered
Joined
·
4,916 Posts
Take a look at my sample workbook. There is a macro called SplitWork that will open a userform with a listbox that will allow you to select the names you would like to use. You can select multiple names in the list by holding the CTRL key while making your selection or you can use the "select all" button to choose all names in the list. Once all the selection(s) have been made you then click the submit button to process them. The list of names that appears in the listbox comes from the worksheet called "Names" so if you want to add additional names all you have to do is go to that sheet and continue with the list in column A.

Rollin
 

Attachments

·
Registered
Joined
·
28 Posts
Discussion Starter · #8 ·
Ok - here is what i want to do now with this macro...i would like to be able to match up the names with the makes. using the same concept of dividing the work between the names and makes...so i may want to split the make "Chevy" between Scott & Kim, give Dawn all the honda or Dawn, Doug, and Bob the honda. or give Dawn the honda, and Bob the ford, and split the rest of the makes between Doug, Kim & Scott....let me know if you understand...this is a little more interactive and in debth. I have found that some of the folks work better with certain makes than others so i would like to give them their makes and then be able to divide the rest of the makes to either 1 or more folks. Thank you.
 

·
Registered
Joined
·
28 Posts
Discussion Starter · #11 ·
I had another thought....there are going to be hundreds of rows of makes and I don't know which makes are in the spreadsheet, it is not always the same, so i was wondering if the macro would be able to display the makes that are in the spreadsheet in the form so that when it pops up i can match up the names to the makes that are actually in that days list....
 

·
Registered
Joined
·
4,916 Posts
I had another thought....there are going to be hundreds of rows of makes and I don't know which makes are in the spreadsheet, it is not always the same, so i was wondering if the macro would be able to display the makes that are in the spreadsheet in the form so that when it pops up i can match up the names to the makes that are actually in that days list....
Yes that's easy. I'll put something together when I have some free time.

Rollin
 

·
Registered
Joined
·
28 Posts
Discussion Starter · #14 ·
Rollin - just so you know, the "make" is in the B column for this project...i figure I'd tell you now rather than me trying to change it and screwing it up like last one!
Thanks!
 
1 - 18 of 18 Posts
Status
Not open for further replies.
Top