Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Excel Sequential Invoice Number in multiple sheets (https://www.askmehelpdesk.com/showthread.php?t=413755)

  • Nov 7, 2009, 09:12 PM
    davtafe
    Excel Sequential Invoice Number in multiple sheets
    Hi

    This is my first time at this site! :) I am a virgin! :p

    I have a master copy of my invoice with the invoice number contained in cell K3.

    I would like to know 2 things which would help me out greatly.

    1. I would like to copy that master sheet invoice say 20 times and have the sheet name down the bottom as 3001, 3002, 3003 etc as each individual sheet name.

    And

    2. I would like the invoice number in K3 to be corresponding to the sheet name - that is running sequentially for each new sheet.

    Hope you can help

    Thanks

    Dave :D
  • Nov 8, 2009, 01:52 AM
    JBeaucaire

    Put this formula in K3:

    =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

    It will cause the sheetname to appear in the cell, so make sure the sheetname is sequentially numbered and your K3 values will match.

    ===========

    Are you asking for help making copies of a template worksheet?

    1) If so, what is the template sheet called?
    2) Do you want a macro to make "x" number of sheets?
    3) Do you want a popup to ask you how many sheets to make?
    4) Do you want the macro to auto-number the sheets based in the current last sheetnumber name? If last sheet is called 3003, then 3004 would be next automatically? Or would you rather have another popup asking for the first sheetname "number"?
  • Jul 5, 2011, 03:00 AM
    RileyElf
    Yes I do you want a macro to copy sheet details and make "x" number of sheets?

  • All times are GMT -7. The time now is 11:40 AM.