bradpallister
New Member
Hello
I have a workbook wich contains a Quotes Register. I have uploaded this file here:- https://www.yousendit.com/download/RIRwSXQwQXBtMEt4dnc9PQ
Ideally, what I wish to do is to fill out the relevant details and then hit a Submit button; this should then open up Quotation Form Template, and insert the Quote No, Quotation Date, Project Number, Project Title and Customer into the relevant cells.
Once I have completed the Quotation, I would then like to hit a Save button, which should save the workbook in a pre-determined location, and also save the workbook as "Quotation" + Quote Number. It should ideally also update the Quote Register with the Quote Value, GP and Margin.
I am a bit thick, how do I go about doing this??
Many thanks
I have a workbook wich contains a Quotes Register. I have uploaded this file here:- https://www.yousendit.com/download/RIRwSXQwQXBtMEt4dnc9PQ
Ideally, what I wish to do is to fill out the relevant details and then hit a Submit button; this should then open up Quotation Form Template, and insert the Quote No, Quotation Date, Project Number, Project Title and Customer into the relevant cells.
Once I have completed the Quotation, I would then like to hit a Save button, which should save the workbook in a pre-determined location, and also save the workbook as "Quotation" + Quote Number. It should ideally also update the Quote Register with the Quote Value, GP and Margin.
I am a bit thick, how do I go about doing this??
Many thanks