Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: A Macro for creating semi-series

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Greetings,
    I would like to thank you in advance for taking your time and reading this post.
    Problem:
    I am trying to write a macro in excel that generates a series, e.g. from 1 to 100 and attaches them to a fixed alphanumeric prefix with a dash separating the two, e.g. : (note: Fill does not do it)

    N180-1
    N180-2
    N180-3

    N180-100

    I would then like to export these generated smi-series to a full page of labels in Microsoft word. Each label in that page gets one of the items generated by excel. e.g.:

    each label looks like the following:

    First label:
    Number: N180-1
    weight: 2KG
    Description: …..

    Second label:
    Number: N180-1
    weight: 2KG
    Description: …..

    etceteras…

    I appreciate your feedback and comments on this. Thank you.
    Sincerely,
    Steve

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can do this with a simple formula...

    In the first column put the values

    1
    2
    3
    4
    etc...

    Then in the second column put the equation

    ="N180-" & A2 <<

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    buggy thing cut half my reply off.

    anyhow, put value 1 in cell a2, and in cell b2 put

    ="180N-" & A2

    ...then fill down and copy to values.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Ahmedabad Gujarat
    Posts
    303
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This what i have exactly shown in my example file no 14 'numbering'

    http://www.pexcel.com/download.htm

    i hope it will be useful to you.

    if you any problem write back to me.

    ni****h desai
    http://www.pexcel.com

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you everyone for the feedbacks.
    Sincerely,
    Steve

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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