Macro to generate the next quote number from another workbook list

I have a quote form that I would like to have a macro run that will generate the next available quote number from a list in another workbook. Example is P160001 is used then I need to return P160002. I'm not sure on how to get the new number generated with VBA if anyone could help. ALso will the quote form log then have this new number saved so that when I go to generate a new on the next number will be chosen?

Here is what I start with to look for a new number but not sure how to create one with the code itself.

Please Login or Register  to view this content.

Thanks.

This should give you an idea of one way to do it.

There is an example file at the bottom.
Here's the code used:

Please Login or Register  to view this content.

I wrote it to cell F2 to show you how to write it back to your sheet.

Since I have no idea of the layout of your quote log, sheet names, ranges the data is in etc...., what am I to do?

See how this works. This code assumes there is at least 1 quote number already in existence.

Please Login or Register  to view this content.