Re-arranging in alphabetical order

[ilinca]

Dear Everybody

I am in a bit of a pickle, officialy I am a super N00B at excel and i need to do the following for work:

I have made a fashion line sheet which has data and images put inside border boxes, which looks like this:

-----> http://img268.imageshack.us/img268/3249/screenshot20120618at125.png

Now the line sheet is in alphabetical order but my boss now wants me to put extra designs in it, meaning i have to move everything around but with it still being in alphabetical order and keeping the same format. Is there any way of moving them around with out having to do it manually one design at a time?

Thanks a lot!

 

[Ten98]

Yes, you could do this in VBA with a lot of work. It would require setting the standard-sized panels up as objects and reading in the names from a certain position within the object, then creating an array of object names in memory and a routine to sort them by swapping data into a defined grid pattern, for example 3 objects wide, 3 rows per page. A talented programmer could do that in a few days, a complete beginner might take a few weeks to learn it all.

Unless you have dozens of lines and this is going to be something you have to do more than a couple of times, then it's not really worth it.

The work involved in writing the sorting program would be more than the time you would save just moving them around one at a time with Cut & Paste.

 

[ilinca]

Hmmm i see..i had a feeling that that might be the case, thank you very much Ten98 for the fast answer!

ps. do you know any good website for excel tutorials?