Results 1 to 10 of 11

Thread: VBA To Separate One Long Row Data Into Multiple Rows Of Fixed Columns

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 08-20-2013, 02:19 AM #1
    rxpsych
    rxpsych is offline
    Junior Member
    Join Date
    Aug 2013
    Posts
    5
    Rep Power
    0

    Question VBA To Separate One Long Row Data Into Multiple Rows Of Fixed Columns

    Good afternoon,

    I copied and pasted a quiz I am set to give on Wednesday (in 2 days) into Excel and it is appearing as one very long row of cells. The question appears in the first cell and then each multiple choice answer (A, B, C, D, etc) are each in a separate cell after. Then it repeats for 50 questions. I would cut and paste them into different rows if it weren't so many questions. So, I have one row with cells A1 to MY1. Each question represents 6 cells in a row (Question + 5 possible answers). I just need to insert a new column after each 6th cell. I've searched the web and many forums and thought I'd find a simple answer to my dilemma, but cannot. I know nothing about writing VBA code, but I know where and how to input it into a macro. Can anyone assist me in task? Thank you in advance.


    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=v_1iqtOnUMg&lc=UgyhQ73u0C3V4bEPhYB4AaABAg
    https://www.youtube.com/watch?v=v_1iqtOnUMg&lc=UgzIElpI5OFExnUyrk14AaABAg. 9fsvd9zwZii9gMUka-NbIZ
    https://www.youtube.com/watch?v=jdPeMPT98QU
    https://www.youtube.com/watch?v=QdwDnUz96W0&lc=Ugx3syV3Bw6bxddVyBx4AaABAg
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=UgxsozCmRd3RAmIPO5B4AaABAg. 9fxrOrrvTln9g9wr8mv2CS
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=Ugw6zxOMtNCfmdllKQl4AaABAg
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=UgyT1lo2YMUyZ50bLeR4AaABAg. 9fz3_oaiUeK9g96yGbAX4t
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=Ugx5d-LrmoMM_hsJK2N4AaABAg.9fyL20jCtOI9g7pczEpcTz
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=UgyT1lo2YMUyZ50bLeR4AaABAg. 9fz3_oaiUeK9g7lhoX-ar5
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=Ugx5d-LrmoMM_hsJK2N4AaABAg.9fyL20jCtOI9gD0AA-sfpl
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=Ugx5d-LrmoMM_hsJK2N4AaABAg.9fyL20jCtOI9gECpsAVGbh
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=Ugw6zxOMtNCfmdllKQl4AaABAg. 9g9wJCunNRa9gJGhDZ4RI2
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 07-20-2023 at 03:02 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Sort Data By Multiple Columns And Delete Some Rows Based On Criteria
    By valesilver in forum Excel Help
    Replies: 6
    Last Post: 08-14-2013, 04:25 PM
  2. Rearrange A Delimited Column Of Data In To Separate Rows With Fixed Number Of Columns
    By digitalcaptive in forum Excel Help
    Replies: 3
    Last Post: 07-29-2013, 11:32 PM
  3. Split Data in Table To Multiple Rows Based On Delimited Text In Columns
    By nick5_86 in forum Excel Help
    Replies: 4
    Last Post: 05-01-2013, 09:49 PM
  4. Split Row Data In To Multiple Columns Based On Delimiter
    By cjjn in forum Excel Help
    Replies: 2
    Last Post: 03-05-2013, 07:34 AM
  5. Transpose Multiple columns data into multiple rows
    By manoj in forum Excel Help
    Replies: 2
    Last Post: 06-14-2012, 04:10 AM

Bookmarks

Posting Permissions

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

Forum Rules