+ Reply to Thread
Results 1 to 10 of 10

Arrange words in 3 columns

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Arrange words in 3 columns

    I have mannually copied 68 to 134 to column E
    I have mannually copied 135 to 201 to column I

    Page 2 needs to start with 202 on on a

    If i play around cut paste it will take ages , want macro to do this for me

    Print Preview has been set 75% so all the 3 columns fit is printable mode

    Macro to the cut paste of this putting the list at 201 every page

    See sample Page 1 down manually

    Find file attached
    Attached Files Attached Files
    Last edited by makinmomb; 02-05-2024 at 04:56 AM. Reason: gram

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,647

    Re: Arrange words in 3 columns

    Demanding and rude:

    want macro to do this for me
    Polite and acceptable:

    I would like a macro for this, please.
    You still have a problem with your manners.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: Arrange words in 3 columns

    AliGW i will try and polish on this let me stay around please , thank you
    Last edited by makinmomb; 02-05-2024 at 05:02 AM. Reason: please

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,647

    Re: Arrange words in 3 columns

    You can stay - I just wish you'd learn some common courtesy. I have reminded you of it too many times. Your helpers deserve to be treated with respect, not like your servants.

  5. #5
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,219

    Re: Arrange words in 3 columns

    Please Login or Register  to view this content.
    Artik

  6. #6
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: Arrange words in 3 columns

    Artik u got me too correct

    The answers went vertical instead of Horizontal

    Someone please look into this , the trick is maybe placing dictionary else where so that results can pour where we need it be

    Thank you Artic very nice try I still can print by highlighting which will be some how long

  7. #7
    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
    28,169

    Re: Arrange words in 3 columns

    Try
    Please Login or Register  to view this content.
    I have not tried over the full dictionary this runs to 50+ pages with 80 rows per page!

    Using "Fit to page" print option you can get 80 rows per page : just change the highlighted value if you want fewer.
    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.

  8. #8
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: Arrange words in 3 columns

    Thank you very much JT
    this is working as intended

  9. #9
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: Arrange words in 3 columns

    Reputation to plug when i have give someone else , 2 consecutive reputations to same person not works

  10. #10
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: Arrange words in 3 columns

    JT reputation added

    Thank you again

+ 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. Replies: 6
    Last Post: 12-21-2023, 05:26 AM
  2. [SOLVED] arrange data based on matching for four columns together with two columns together sheets
    By Mussa-A in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-17-2022, 05:36 PM
  3. Replies: 4
    Last Post: 08-15-2018, 11:41 AM
  4. [SOLVED] Compare words in 2 columns, formula for unique words in 3rd column
    By thecdnmole in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-08-2018, 01:58 PM
  5. Compare words in 2 columns, formula for unique words in 3rd column
    By thecdnmole in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-07-2018, 06:26 PM
  6. [SOLVED] How to arrange two columns like this
    By elbrujo in forum Excel General
    Replies: 5
    Last Post: 04-23-2015, 08:15 AM
  7. Replies: 1
    Last Post: 01-03-2013, 01:28 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1