Re: incrementing batches of numbers

Discussion in 'Microsoft Excel Worksheet Functions' started by Don Guillett, Mar 26, 2012.

  1. Don Guillett

    Don Guillett Guest

    On Monday, March 26, 2012 10:31:10 AM UTC-5, joe74 wrote:
    > I have a sheet, where I need to batch 500 products each containing 26
    > rows of information (13000 rows). after each batch of 26 there must be a
    > space, which I have set up.
    >
    > I now need to add in column 1 an SKU number for each batch, starting at
    > SKU-00001 going upto SKU-00500.
    >
    > I am wondering is there a way of using the drag and fill to run these
    > numbers consecutively in batches of 26, to save me having to edit each
    > one?
    >
    >
    >
    >
    > --
    > joe74


    Sub numbersincolumn()
    n = 1
    For i = 1 To 500 Step 26
    Cells(i, 3).Resize(26).Value = "00A" & n
    n = n + 1
    Next i
    End Sub
     
    Don Guillett, Mar 26, 2012
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.

Share This Page