I am trying to create a quote database to maintain the enquiries I receive. I would like to enter few fields in a form. once I enter the details, I want it to create a sequntial quote number, create new folder in a specific location and hyper link the quote number cell to the respective folder.

Is it possible to do this in Excel?

Thanks a lot for the help and advise, in advance!

Cheers!
Nandha