hi,
I want to make a series of voucher number. If my first voucher No. is 1001 after i save it and open it again the number will change to 1002. is this possible?
hi,
I want to make a series of voucher number. If my first voucher No. is 1001 after i save it and open it again the number will change to 1002. is this possible?
It is very difficult to do without a macro. You could do this in the open routine.
Regards,
amotto
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
can you give me a method or formula on how to do this in macro?
Put this code in the ThisWorkbook routine, and change the cell reference as needed
Private Sub Workbook_Open()
Range("A2").Value = Range("A2").Value + 1
End Sub
Thanks. it helps a lot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks