Consulting

Results 1 to 5 of 5

Thread: Transpose numerous rows in columns to a selected number of columns

  1. #1
    VBAX Newbie
    Joined
    Jul 2022
    Location
    Roodepoort
    Posts
    4
    Location

    Transpose numerous rows in columns to a selected number of columns

    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.
    Greetings
    Attached Files Attached Files

  2. #2
    i have tried and not so pretty.
    Attached Files Attached Files
    Last edited by arnelgp; 07-11-2022 at 08:23 AM.

  3. #3
    VBAX Newbie
    Joined
    Jul 2022
    Location
    Roodepoort
    Posts
    4
    Location
    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.

  4. #4
    VBAX Newbie
    Joined
    Jul 2022
    Location
    Roodepoort
    Posts
    4
    Location
    And I just learned about Ubound!

  5. #5
    if there are Keywords that are not familiar to you, just
    search it in the web. that is learning time for you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •