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.
Similar Threads
  1. WikedClown

    Incrementing all numbers in a column

    WikedClown, Nov 27, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    163
    Paul B
    Nov 28, 2003
  2. Guest

    print tickets with incrementing numbers in Excel ?

    Guest, Feb 22, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    450
    Gord Dibben
    Feb 22, 2005
  3. Floyd107

    Incrementing numbers

    Floyd107, Feb 28, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    173
    MartinW
    Feb 28, 2006
  4. Andrew Morine

    Incrementing numbers in cells

    Andrew Morine, Aug 26, 2008, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    120
    Teethless mama
    Aug 26, 2008
  5. AJ

    Incrementing numbers problem

    AJ, May 22, 2009, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    105
    OssieMac
    May 23, 2009
Loading...

Share This Page