SNACKOLOGY
New Member
- Joined
- Jul 29, 2007
- Messages
- 3
Hi ppl,
I am a complete novice so please be patient!
I have a workbook, with 226 seperate sheets enclosed. What I would like to do is to put an invoice number in the first sheet's invoice number cell and then the remaining sheets auto add a 1 to make up the next invoice.
For example, if I were to put 1200 into sheet 1's invoice cell, sheet 2's invoice cell would read 1201 and so on. All invoice cells are in the same place and are in B2.
Until I found this board I have had to do this manually! I know nothing about VB but can bake a nice cake if that will help
Thank you in anticipation of your help.
Richard
I am a complete novice so please be patient!
I have a workbook, with 226 seperate sheets enclosed. What I would like to do is to put an invoice number in the first sheet's invoice number cell and then the remaining sheets auto add a 1 to make up the next invoice.
For example, if I were to put 1200 into sheet 1's invoice cell, sheet 2's invoice cell would read 1201 and so on. All invoice cells are in the same place and are in B2.
Until I found this board I have had to do this manually! I know nothing about VB but can bake a nice cake if that will help
Thank you in anticipation of your help.
Richard