incrementing batches of numbers

[joe74]

I have a sheet, where I need to batch 500 products each containing 2
rows of information (13000 rows). after each batch of 26 there must be
space, which I have set up.

I now need to add in column 1 an SKU number for each batch, starting a
SKU-00001 going upto SKU-00500.

I am wondering is there a way of using the drag and fill to run thes
numbers consecutively in batches of 26, to save me having to edit eac
one

 

[Don Guillett]

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?

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

 

[joe74]

;1600216']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 b a
space, which I have set up.

I now need to add in column 1 an SKU number for each batch, startin 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 edi each
one?

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

Hi Don, I may be being a nugget here, but I dont know what you mea