+ Reply to Thread
Results 1 to 2 of 2

AUTO GENERATE NUMBERS to antoher worksheet

  1. 04-26-2013, 04:19 PM #1
    wstring
    wstring is offline
    Registered User
    Join Date
    03-20-2012
    Location
    LA
    MS-Off Ver
    Excel 2007
    Posts
    32

    AUTO GENERATE NUMBERS to antoher worksheet

    I'm trying to write a macro to lookup the last number used in a column and auto generate the next number on another worksheet. This is what I have so far, the number changes but not base on the last number.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Leith Ross; 04-26-2013 at 04:21 PM. Reason: Added Code Tags
    Reply With QuoteRegister To Reply
  2. 04-26-2013, 04:26 PM #2
    111StepsAhead
    111StepsAhead is offline
    Forum Contributor
    Join Date
    04-11-2011
    Location
    Columbus, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    325

    Re: AUTO GENERATE NUMBERS to antoher worksheet 

    Please Login or Register  to view this content.
    This code takes the last number on Sheet1 and puts that number plus one on sheet2 cell A1. The code should help you understand how you call values on other sheets.
    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)

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