VBA Sorting Nth Range not working

I have a values in column C of stuff1, stuff2 and on down.

I have a value in cell A1.

I want to start in C1, and every Nth, where N is the value in cell A1, select and paste into column H.

My problem is that the selected cells don't start in C1, in fact, based on the value in A1, it starts in different cells in column C. AND, if i press the button twice, the returned values are different.

Please Login or Register  to view this content.

Link to source code
i've attached a sample.

Thanks Roger,

I'm still getting the same results:

i.e.

A1= 1 works
A1= 2 starts at "stuff99" and every 2 on down
A1= 3 starts at "stuff79" and every 3 on down
A1= 4 starts at "stuff53" and every 4 on down
A1= 5 starts at "stuff31" and every 5 on down
A1= 6 starts at "stuff7" and every 6 on down
A1= 7 works

A1= 8 and more, the code works fine for me. I've yet to try it on another machine, but i must use this code on this machine, so i have to figure this out.

the final result, is that i want to have the value in A1 be the # of personnel reporting, and divy up the part to be made based on that value into each persons list of work, so i have to start with C1 as the first part to be made, not part 99 or 73 etc.

Thanks Leith. perfect.

Next question. Since i'm going to be copying every Nth starting in C1 for person 1, and i'm going to be copying every Nth starting in C2 for person 2,

• should i use another button for person 2
• should i reset the variables after the "next cell" with a valkill and reassign for person 2
• should i create new variables for person two, and simply repeat the programming appropriately

Thanks in advance for all your help, this is as complicated as i've gotten with programming, and I LOVE it.

ColumnK.

This is what i have so far.

Please Login or Register  to view this content.

What i think i need to do, is assign each "person" to a "sub."

So, i'll do something like:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Now, what it appears i need next is an if then statement, but there should be a more elegant solution to this. I'm going to call only Person_1 if the value in A1 is 1. I'm going to call Person_1 and Person_2 if the value in A1 is 2.

So this is what i have figured out so far, but i need to assign some "ifs" based on the value in A1...

Please Login or Register  to view this content.

I found this Here

Please Login or Register  to view this content.

But i can't figure out how this applies to what i'm doing exactly. I'm sure that i'll have to change the Case statements to:

Please Login or Register  to view this content.

Originally Posted by Leith Ross

Hello Beechum1,

The same macro can be used for all persons. It just requires some slight changes. How many persons will there be?

up to 10, but variable daily.


and to be clear, my trigger is CommandButton1_Click

Originally Posted by Leith Ross

Hello Beechum1,

You say the number of persons will vary daily. I take it that each person will have a number in column "A", right?

to be clear, the number of persons will be the value in A1. It appears i've figured it out though, the previous attached file, i've built out to person_6 and appears to work perfectly.

Attached is my current ver.

next step is to only copy and paste 20 rows in each column. I have fixed space to paste to in my programming area. Seems like a for... next loop, but i haven't figured out the placement, can someone get me started?
attached above is the most recent testing version of this problem.