I need to generate a number based on month,Year-Four digit number. The VB would need to look to sheet3 Column A and go to the last number used then add one to that number and place that in say Sheet1 "J5". The numbers would need to start over every Month at 0001