devide numbers and duplicate one spesific cell number

[fakhteh]

hi
i want a macro code that devides numbers to 49 and then the number of (49) cell duplicate for the first number of next row. i have attached the excel file .the sheet number 2 is my data and the sheet 1 is the sheet that i want.

[JLGWhiz]

Is this what you mean?

Please Login or Register  to view this content.

[fakhteh]

hi again
MR JLGWhiz
your code answer is perfect but i think just one number must be changed in all of the code
maybe my example was not correct so i edit and attached another one(book3) in my post.
please check it
i appreciate your help

[JLGWhiz]

Rather than keep changing your data base, just use the original example and try this modified code.

Please Login or Register  to view this content.

[fakhteh]

Hi Mr JLGWhiz
please use your code in macro and see the result i think you can find that which lines of code must be correct
i use your code and i understand that maybe it is better to use times of 49 for example 1*49 and then 2*49 for finding the number that must be duplicated and set for the end of previous row and also set at the beginning of next row .
thank you so much

[JLGWhiz]

If you are only using 49 columns, then only the first row can have 49 unique entries. After that it will be the last number of the previous row plus 48 new unique entries.
Otherwise, the first row will be 49 columns and the remaining rows will be 50 columns (last number of previous row + 49 new unique numbers) with the last row being of whatever number of columns <= 50. So if you can explain how you want the column counts to end up, maybe I can get it to produce the results you want.

[fakhteh]

hi
it was my fault. i apologize of you and every one.
forgive me