+ Reply to Thread
Results 1 to 4 of 4

Auto Fill a Column with repeating numbers

  1. #1
    Registered User
    Join Date
    12-04-2012
    Location
    Oregon
    MS-Off Ver
    Excel 2010
    Posts
    13

    Auto Fill a Column with repeating numbers

    I have a spreadsheet that lists numbers in a column. They increase 1 number at a time, however the same number is listed 24 times before increasing to the next. Scaled down to 3 times it would look like this: 111, 222, 333, 444, 555, each one of those individual numbers would have their own cell. When I highlight the column and drag down, it starts doing decimals..how do I get it to recognize it? sample.xlsx

    I want to drag it down to continue the pattern. Right now, I type a couple of numbers and drag to finish the section.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Auto Fill a Column with repeating numbers

    Based on your sample workbook to row 250...

    I imagine there may be a formula but not sure how...

    Please Login or Register  to view this content.
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    12-04-2012
    Location
    Oregon
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Auto Fill a Column with repeating numbers

    Should I be able to plug that formula in? Where at? I am familiar with basic excel, but I haven't done formulas in that sense before. This is a spreadsheet that I updated as units are produced and recorded in this spreadsheet. So..the formula would have to allow me to edit it daily as more units are entered in. There are other columns involved as well, however I only fill in this one (thus, the formula would have to only effect this column). Thanks!

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Auto Fill a Column with repeating numbers

    This is a normal macro...

    Place in normal module
    • Highlight macro to copy >> Ctrl + C >> Open your workbook
    • Alt + F11 >> opens the Visual Basic Editor (VBE)
    • Ctrl + R >>opens the Project Explorer (if not already open on left side of screen)
    • Insert menu >> Module or Alt + I, M >> activates the Insert menu and inserts a Standard Module
    • Paste code >> Ctrl + V (right side of screen)
    • Alt + Q >> exits VBE and returns to Excel
    • Back in Excel >> Alt + F8 >> Macro Dialog Box >> Highlight macro >> Run

    The results will be shown in A1 until the loop ends at row 250

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1