+ Reply to Thread
Results 1 to 4 of 4

Split values into columns with setting specific nr. of rows per column

  1. #1
    Registered User
    Join Date
    02-19-2021
    Location
    Brno, Czech republic
    MS-Off Ver
    365 ProPlus
    Posts
    4

    Split values into columns with setting specific nr. of rows per column

    Hi,

    I got a new laptop at work and forgot to save my macros from "personal" in the old one before it was gone. I could recreate all but one that was not mine, I found it somewhere online and cannot find it again for the love of me.

    Basically it was a macro to split data from one cell into multiple columns, but it had 2 popups - first asked about the starting cell for the split data to start in and second asked for number of rows per column. So you would run the macro, a popup nr. 1 would ask you to select the cell for the split data to be pasted (starting point) and then popup nr. 2 came up with a text field for you to write how many rows per column you want.

    E.g. you have 100 values separated by comma in cell A1.

    First popup - you select cell B1.
    Second popup - you write "20"
    Result - the 100 values will be split in 5 columns, 20 rows per column (meaning in range B1:F20).

    If you would write "30" in the second popup, the values will be in 4 columns, 30 rows per column (4th column obviously with only 10 remaining values).

    I made an example, see attached.

    I tried to look for it online, because I don't remember anymore where I had it from and I seem to be unable to find it again. Can someone please help?

    Thanks a lot!
    Kathi
    Attached Files Attached Files
    Was forced to live on this planet, wanna leave!

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    29,824

    Re: Split values into columns with setting specific nr. of rows per column

    Please Login or Register  to view this content.
    Attached Files Attached Files
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Registered User
    Join Date
    02-19-2021
    Location
    Brno, Czech republic
    MS-Off Ver
    365 ProPlus
    Posts
    4

    Re: Split values into columns with setting specific nr. of rows per column

    OMG Thank you! You´re the best! ❤

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    29,824

    Re: Split values into columns with setting specific nr. of rows per column

    Glad to have helped and thank you for the rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA to split 2 column B&D values rows depends upon values from sheet column A&B
    By johnlara in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-30-2023, 05:30 PM
  2. Replies: 2
    Last Post: 02-18-2020, 12:51 AM
  3. [SOLVED] Edit vba to split values over 10 columns and required rows
    By JNEWMAN in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-01-2019, 11:16 AM
  4. Split data into multiple columns and rows based on specific string
    By qiyusi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-13-2018, 02:01 PM
  5. Split Column into Multiple Columns Based Off Specific Criteria
    By hellzone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-31-2017, 09:49 PM
  6. Transpose values in column to rows, and split cell values to extend column
    By SAMMM in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-03-2015, 12:52 AM
  7. [SOLVED] Split specific chars in one column to other columns with no delimiter
    By Fjalar in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-21-2013, 12:28 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1