Results 1 to 2 of 2

Auto serial numbers across multiple work sheet in a workbook in a particular cell

Threaded View

subhassamuel Auto serial numbers across... 10-19-2013, 05:24 AM
mrice Re: Auto serial numbers... 10-19-2013, 05:43 AM
  1. #1
    Registered User
    Join Date
    10-19-2013
    Location
    Chennai, India
    MS-Off Ver
    Excel 2007
    Posts
    1

    Auto serial numbers across multiple work sheet in a workbook in a particular cell

    I need help on the following subject.

    Is it possible to create serial numbers across multiple work sheets in a particular cell in a work book, if possible the same no should reflect on the sheet tab. This method would be more useful in generating invoices in excel.
    Example : If I open 100 sheets in a work book , If I put serial no 1020 in sheet 1 in cell no c3 the remaining 99 sheets should get serial nos like 1021,1022,1023 etc in the same cell no c3, if possible the same serial no should reflect on the sheet tab, instead of renaming the sheet tab manually for all the 100 sheets.

    Presently I am creating around twenty invoices per work book for my company for which I have created an excel file consisting a Macro called “SPELL NUM” which converts number in to text, drop down list in 12 cells, Sum formulas and V lookup formulas in 12 cells.

    My work book consists 24 sheets (20 invoice sheets, one summary sheet and three data sheets. The templates between the invoice sheets and other sheets are different, if I run the requested macro, it should not dysfunction the existing macro, dropdown list and other formulas and it should also not disturb the non invoice sheets and its functions

    I am herewith sending my sample workbook in which the requested macro has to work only in first 20 work sheets (which have invoice templates) without disturbing the other sheets, existing macro and formulas. Kindly extend your generosity.

    Thanks & Regards
    M.SUBHAS SAMUEL.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Removing multiple spaces from within serial numbers
    By JHArizona in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-09-2012, 06:09 PM
  2. Purchase form with auto-sequential serial numbers
    By psanghvi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-25-2012, 05:40 PM
  3. Auto serial the cell which has same value
    By sanketgroup in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-14-2010, 12:33 PM
  4. Replies: 2
    Last Post: 03-04-2010, 10:12 PM
  5. Finding a serial number in a list of serial numbers
    By zocoloco in forum Excel General
    Replies: 2
    Last Post: 02-04-2009, 05:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1