Want to transfer the data from one cloumn to other columns

[Vikas_k]

Dear All,

I have got stucked on below problem,request you to please provide a solution on the same.

Ihave some numbers arround 1 lac nos in column 'A'and I want to make a group 200 numbers and transfer it in to next next column .i.e 1-200 numbers in column 'B', 201-400 numbers in column 'C' etc.

kindly provide a solution with any macro or vba thing or else formula can be used

Regds
Vikas

[Kaper]

in B1:

Please Login or Register  to view this content.

copy down 199 rows (downto 200), right as many columns as needed.

Once you like the result, copy and paste special as values only.
Now delete column A, and that's it.

[morevijay1982]

If it is in series without missing a single no then use like this a1+1 in cell a2 to a199+1 in cell a200 and in next column b use =A200+1

[morevijay1982]

dear kaper u r genious

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Vikas_k]

Dear All,

Thank you so much, I have not tried VBE Codes yet but tried formula and it is worked