TechRepublic|Forums|Community

Community

General discussion

  • Creator
    Topic
  • May 4, 2003 at 8:54 pm #2307085

    Excel problem VBA/macro

    Locked

    by haarsaker · about 19 years ago

    I have a specific problem concerning VBA/macro:

    I need a macro that reads the contents of 2 cells A1 and B1 (both numeric) then creates new string values by combing these values and fills in new these stringvalues in the A-column starting in cell A2 and continuing downwards the number of times equaling the number from cell B1.

    The stringvalue should be like this THE_CONTENT_FROM_A1 +’/’ + the stringvalue from 0 to the value from cell B1 – increasing with ONE from one row to the next:
    i.e:

    if A1=Oslo345 and B1=5

    the result:
    B2=Oslo345/1
    B3=Oslo345/2
    B4=Oslo345/3
    B5=Oslo345/4
    B6=Oslo345/5

    Anyone ?

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Comments