Hi everyone,

I am new but getting serious as the boss is killing me everyday.
I working on invoice and quotation system.

My plan is:

1) Quotation is create
2) There should have a master list a quotation has been issued out.
3) When creating a new invoice (in the invoice template) by drop down a quotation number #, all the details (description,amount) is automatically shown. As the new created invoice is mirror to mirror with the quotation.
4) The created invoice also has a master list.

Can this be done? I am very new with VBA.

Please show me. I am run out of time. I have my excel, but the plan is not similar as what I looking for. I created the invoice master list (need to manually enter all data), then the Vlookup formula is use when to issued a new template for invoice. But the quotation# has to manual keyed in.