davtafe Posts: 1, Reputation: 1 New Member #1 Nov 7, 2009, 09:12 PM
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
 JBeaucaire Posts: 5,426, Reputation: 997 Software Expert #2 Nov 8, 2009, 01:52 AM

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"?
 RileyElf Posts: 1, Reputation: 1 New Member #3 Jul 5, 2011, 03:00 AM
Yes I do you want a macro to copy sheet details and make "x" number of sheets?

 Question Tools Search this Question Search this Question: Advanced Search

Check out some similar questions!

Sequential numbering in Excel [ 3 Answers ]

Hi, I'm trying to number a column in sequential order by counting the number of times a certain word is typed in another range. For example: AAA 1 BBB 1 AAA 2 AAA 3 CCC 1 I need the numbers to be in sequence in column B:B every time a word is typed multiple times in column A:A.

Excel 2003 Macro VBA Hide / Unhide Multiple Sheets [ 5 Answers ]

I'd like to assign a macro button to hide / unhide a range of sheets in a workbook. I have tried various codes from web but have not been successful. (acutally one of the codes worked if I selected 'run' from the macro menu but does not run if button is clicked). I have tried 'recording'...