Dear All,

I need help in making a Quotation database. Every time a quotation is sent it has to be saved and a new worksheet should be present in order to make a new quotation. The Quotation numbers should auto populate on the new worksheet. There would be drop downs for - Client names and addresses and Project names. We are looking at making something that would show us the number of quotations sent and the conversion rate. I have prepared that, However as mentioned at the beginning. I'm facing a problem making the Quotation sheets. Kindly do help. I'm new to excel and I'm just all over the place.

Thanks in advance.

Have a good day!

Regards,
Henry