+ Reply to Thread
Results 1 to 8 of 8

Need a code to print Alphabet sequence also number sequence simultaneously in a column

  1. #1
    Registered User
    Join Date
    05-29-2015
    Location
    India
    MS-Off Ver
    2013,2010
    Posts
    12

    Post Need a code to print Alphabet sequence also number sequence simultaneously in a column

    A
    B
    C
    D
    E
    10
    20
    30
    40
    50
    60
    70
    80
    90

    Need a code write above sequence. with a validation point after which the Numering of integers starts following alphabets sequence

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Need a code to print Alphabet sequence also number sequence simultaneously in a column

    I'd feed them into an array variable, either dynamically or manually.

    Then use of Mod can be used to invoke then in a roll.

    I put your variables from A1:A14.

    Then I used the following code:
    Please Login or Register  to view this content.
    This printed a repeating sequence of the first 50 outputs in column D.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Need a code to print Alphabet sequence also number sequence simultaneously in a column

    And manually with a static reference:

    Please Login or Register  to view this content.

  4. #4
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Need a code to print Alphabet sequence also number sequence simultaneously in a column

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  5. #5
    Registered User
    Join Date
    05-29-2015
    Location
    India
    MS-Off Ver
    2013,2010
    Posts
    12

    Re: Need a code to print Alphabet sequence also number sequence simultaneously in a column

    Hi thanks for the help... also is there a way i can validate the numbering and code for following data

    A 231
    B 12e
    C qwe
    D r3
    10 Login
    20 qwe
    30 asd
    40 qwe
    as soon as "login" word is present it should start numbering sequence and end till it finds blank cell in adjacent column

  6. #6
    Registered User
    Join Date
    05-29-2015
    Location
    India
    MS-Off Ver
    2013,2010
    Posts
    12

    Re: Need a code to print Alphabet sequence also number sequence simultaneously in a column

    Quote Originally Posted by daffodil11 View Post
    I'd feed them into an array variable, either dynamically or manually.

    Then use of Mod can be used to invoke then in a roll.

    I put your variables from A1:A14.

    Then I used the following code:
    Please Login or Register  to view this content.
    This printed a repeating sequence of the first 50 outputs in column D.
    Thanks for the help

  7. #7
    Registered User
    Join Date
    05-29-2015
    Location
    India
    MS-Off Ver
    2013,2010
    Posts
    12

    Re: Need a code to print Alphabet sequence also number sequence simultaneously in a column

    Quote Originally Posted by mehmetcik View Post
    Please Login or Register  to view this content.
    Thanks for the help.... i could use some part of the code
    I am not getting desired output.. it does not print till in required cells but also prints the sequence in other rows

  8. #8
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Need a code to print Alphabet sequence also number sequence simultaneously in a column

    Looks good to me. You'll need to have the sequence listed for it to reference.

    See Attached.
    Attached Files Attached Files

+ 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. Hep filling column with a number sequence whenever value changes
    By kkxm in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-13-2014, 02:00 PM
  2. [SOLVED] Need VBA code to border tables, put hedders on them & number them in sequence
    By amy_d2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-28-2013, 03:57 PM
  3. [SOLVED] Creating a sequence based on numbers in one column and adding "01,02..." to a new sequence
    By JCR1968 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2013, 08:06 AM
  4. Replies: 0
    Last Post: 12-12-2012, 06:39 PM
  5. Excel 2007 : print number sequence on 2 part ncr paper
    By quinterod in forum Excel General
    Replies: 1
    Last Post: 03-31-2011, 10:35 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