hellfire45
Active Member
- Joined
- Jun 7, 2014
- Messages
- 462
Thanks for reading. Allow me to explain what is happening. I have a spreadsheet into which rows of data are imported daily. I also have 10 people who need to receive the work evenly distributed. I need the program to:
copy data row 1 and paste the data to worker worksheet 1, then,
copy data row 2 and paste the data to worker worksheet 2, then,
copy data row 3 and paste the data to worker worksheet 3, then,
copy data row 2 and paste the data to worker worksheet 4, then,
copy data row 2 and paste the data to worker worksheet 5, etc...
After the 10th worker gets a row of data, I need it to go back and start over again with worker number 1.
I need this process to occur until everybody has 120 distributions OR until the raw data pile runs out of rows.
I think maybe this isn't that hard but I'm a newbie. Can anybody help me out with this?
Thank you so much!
copy data row 1 and paste the data to worker worksheet 1, then,
copy data row 2 and paste the data to worker worksheet 2, then,
copy data row 3 and paste the data to worker worksheet 3, then,
copy data row 2 and paste the data to worker worksheet 4, then,
copy data row 2 and paste the data to worker worksheet 5, etc...
After the 10th worker gets a row of data, I need it to go back and start over again with worker number 1.
I need this process to occur until everybody has 120 distributions OR until the raw data pile runs out of rows.
I think maybe this isn't that hard but I'm a newbie. Can anybody help me out with this?
Thank you so much!