Shuffling values into appropriate columns

Hello, I have bunch of data in a worksheet with a header. I need to shuffle the data into appropriate columns without having to paste each value individually. Is there anyway to do that? I found an older threat from 2010 where this was done successfully. I proved it by downloading the sample spreadsheet and macro and running it. However, I could not adjust the syntax for my particular table. The macro only succeeded in mixing up the data.

As can be seen in the attached sample table, I wish to shuffle the values (1 to 12) into their respective columns (B to M). The full table has 2,400 rows with 4,600 values, hence, the necessity of a macro.

Thank you for any guidance.

If I've understood the request correctly AND your original data looks as I figured, then perhaps this will work?

Please Login or Register  to view this content.

BSB

That is IT, sir! Thank you! What amazes me is that the syntax is relatively short, at least compared to the macro I was toying with from another thread.

There are often many ways to accomplish the same thing in Excel. Some people write lots of code and some do the opposite. I'm sure if someone put their mind to it they could write a sub even shorter than my example for you.
I just like to keep it simple and easy to understand.

Glad it does what you need and happy I could help

BSB

Thanks again. You kept it simple for sure, but as for ease of understanding, well, it takes a bit of experience with excel syntax, I'm sure. My wife was astonished by it: "You mean you can program for excel?!" She's a biostatistician and programs for SAS, and I have written applescripts for Quark Xpress and OSX. Yet between us, we spent an inordinate amount of time defining each line of the macro above. I think we understand most of it

Give me a shout if you need any of it explaining. It's a very straightforward language once you get your head around the syntax.

BSB