PC Review

Thread Tools Rate Thread

Re: incrementing batches of numbers

Don Guillett
Posts: n/a
      26th Mar 2012
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
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
incrementing page numbers for non-sequential numbers Mark Hoptiak Microsoft Word Document Management 1 30th Jan 2010 10:45 PM
Assigning numbers in batches John Microsoft Access 3 12th Feb 2006 09:03 PM
Assigning numbers in batches John Microsoft Access Queries 3 12th Feb 2006 09:03 PM
Can no longer print batches of files from briefcase =?Utf-8?B?QmVuZWZmZXI=?= Windows XP Help 0 23rd Jun 2004 01:28 AM
Auto Incrementing Numbers (missing numbers) =?Utf-8?B?RG91Zw==?= Microsoft Access Database Table Design 2 17th Feb 2004 03:08 AM




All times are GMT +1. The time now is 07:23 AM.