Hi Everyone,

I am hoping you can help me, I would like to create an excel spreadsheet that can do the following.

Based on a users radio button input/option, it create the prefix "A" "B" "C" or "AB" etc.. and then for each of those prefixes it automatically look at the last highest number and provide the next sequential number and once it has created that number automatically or provide a button to email that created cell to the designated email address.

For example:
What is the type of document you are wanting to create? (has a drop down of A, B, C, or AB)

then if they had selected "A"

It would look at all the A's. .. A0081, A0082, A0083 and then since A0083 is the last one in the list, it automatically generate me A0084.

I hope I have explained this properly/clearly, if you need any further clarification please let me know.

Thanks in advance, I love this forum, been lurking for a while but couldn't find anything that was similar to my question.

Best Regards,

Dean