View Full Version : Transpose numerous rows in columns to a selected number of columns

07-10-2022, 09:45 AM
Hi all,
I decided to take on VBA as a hobby for the next few months, but before I can do that I need to finish one project.
To do that, I need to transpose Hebrew, Greek, and Arabic words, all in cells in Column A, followed by the Transliteration of the Hebrew Greek and Arab script into the Roman Alphabet all under column B, then I add my translation into English in Column C.

This is the data already in my posession.

I now need to transpose this data of all these cells in say 3 Columns (A1, A2, A3) then (B1, B2, B3) and so on, to N ammount of columns.

lets say I choose 10 columns (as the target area) because it will fit on my chosen page size.
I managed to get a nice Macro from the internet, but it has a shortcomming. It Transposes, but it does not copy the FORMAT of the original Cells.

I will appreciate it if someone can use my attached workbook to tell me what I should do.

For this example sheet I choose to have 10 columns as the endresult, with 3 cells from the source rows.
So with the input boxes enter 10 then 3 to see my result.

07-11-2022, 06:30 AM
i have tried and not so pretty.

07-11-2022, 10:06 AM
But, I like it because I see a total different way to write the instructions.
Becaue I am still new to VBA, It is some more variants I can play with.
Thanks a lot.

07-11-2022, 10:20 AM
And I just learned about Ubound!

07-11-2022, 05:07 PM
if there are Keywords that are not familiar to you, just
search it in the web. that is learning time for you.