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