+ Reply to Thread
Results 1 to 3 of 3

Macro to auto increment number

  1. 07-13-2015, 02:52 PM #1
    asianqueen
    asianqueen is offline
    Registered User
    Join Date
    06-05-2013
    Location
    Asia
    MS-Off Ver
    O365
    Posts
    11

    Macro to auto increment number

    I have A2 = 1, B2 = random value.

    What I want is each time I insert a new value on B columns that A columns auto increment with it.
    Reply With QuoteRegister To Reply
  2. 07-13-2015, 07:02 PM #2
    protonLeah
    protonLeah is online now
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,959

    Re: Macro to auto increment number

    In A2 (copied down):
    Please Login or Register  to view this content.
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  3. 07-13-2015, 07:28 PM #3
    asianqueen
    asianqueen is offline
    Registered User
    Join Date
    06-05-2013
    Location
    Asia
    MS-Off Ver
    O365
    Posts
    11

    Re: Macro to auto increment number

    wow, that worked also...

    Thanks
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA/Macro for Copying Purchase Order Form to a New Tab, Auto Increment the Tab number.
    By joemi in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-06-2015, 11:44 AM
  2. auto increment number with date
    By m_k in forum Excel General
    Replies: 6
    Last Post: 03-17-2012, 09:33 AM
  3. How do I auto increment row number in pasting macro? (Code inside)
    By paulishuku in forum Excel General
    Replies: 3
    Last Post: 02-09-2011, 08:40 PM
  4. Excel number auto increment help!
    By Talmac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-19-2010, 04:52 AM
  5. How to auto-number (increment) invoices in Excel?
    By Pheasant Plucker® in forum Excel General
    Replies: 1
    Last Post: 09-08-2005, 09:05 AM
  6. Generate auto increment number from VB form
    By john_t_h in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-06-2005, 06:19 PM
  7. Auto Increment for Form Number...NEWBY
    By piranhagirl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-16-2005, 10:02 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1