Range to Columns and Rows

[Orum]

Hello there,

I would like to set up a macro that allows me to input a range (numerical or alpha numerical) and have it put that range into a specified number of columns and rows. The amount of columns, rows and range would be different each time. It would be great to do this from the quick access tool bar. I have attached an example which will explain what I'm talking about, hopefully.

Example-02.xlsx

Example 1.
Range: 001 to 120
Columns: 4
Rows: 6

Example 2.
Range: 001 to 120
Columns: 6
Rows: 3


Many thanks for any help/advice you can give me.

Paul

[hemesh]

1.Below code will work for integers only
2.Start Number Should be lesser compared to end number
3.open excel press Alt+F11 then hit Alt+i+m copy paste code and then close opened window go to excel hit alt+F8 a window will open click ranging
from there and click Ok

Please Login or Register  to view this content.