Auto generate number???

I have a few questions regarding a workbook I am working on.

Cell A1 Date
Cell B1 Clause number (generated via vlookup)
Cell C1 Activity number
Cell D1 Description
Cell E1 Voucher Type
Cell F1 Voucher Number
Cell G1 Expense

Is it possible to have Cell F1 generate a number based on Activity number beginning with the number 1 and when another entry occurs with the same activity number occurs on a different date it places the same number generated in a cell beside it? when another activity occurs it needs to add 1 to the previous voucher number.

I can have several expenses for an activity occur throughout a month but only need to create one voucher per activity at months end. This is done via a pivot table which I have already created.

This has stumped me.

Hi Carim,

I had a look at that site, thanks for the link. However I may have not explained what I want to do correctly.

I have attached a sample sheet that I made up.

Hi VBA Noob,

Thanks for the formula. Now I need to go try to understand how it works....

I will let you know if I can make it work in my workbook.

Thanks again.