Dear Experts,
I using creating six types of formats gold and silver sales. I want VBA help for below my requirements.
My requirements.
1. I want use one of the above format by sales so I going to click the any one of format that particular format will appear in EST01 sheet automatically.
2. I want autocomplete product while typing in description fields Ex. If I going to type Ch for chain the chain name will appear in the same field.
3. Auto insert delete next row after enter "J12" cell in estimate fields and old purchase fields "I17" cell with auto serial number in estimate fields except first row in both fields.
4. Auto update purity is "916" in purity fields.
5. Auto update purity is "NK" in purity fields.
6. Auto update rate based on 916 & NK purity the rate same for both purity.
7. Auto change date day by day Ex. Today is 01/01/2021 then next day is 02/02/2021.
8. Auto copy sheet with rename by previous estimate number continuation at same time update the target cell "J6".
9. Auto clear contents in customer details, estimate fields, old purchase fields while create copy sheet.
10. Auto update sales report and customer details one by one after estimate creation.
11. Please make button click for above all formats and copy sheet.
12. I want all format button click in each and every sheet.
13. I want auto print setup page for print estimate.
I want the all above requirements for "Full Automated Estimate" creation. My humble request to help with VBA function.
I have attached here my requirement file for kind reference.
Lot of thanks and regards.
I using creating six types of formats gold and silver sales. I want VBA help for below my requirements.
My requirements.
1. I want use one of the above format by sales so I going to click the any one of format that particular format will appear in EST01 sheet automatically.
2. I want autocomplete product while typing in description fields Ex. If I going to type Ch for chain the chain name will appear in the same field.
3. Auto insert delete next row after enter "J12" cell in estimate fields and old purchase fields "I17" cell with auto serial number in estimate fields except first row in both fields.
4. Auto update purity is "916" in purity fields.
5. Auto update purity is "NK" in purity fields.
6. Auto update rate based on 916 & NK purity the rate same for both purity.
7. Auto change date day by day Ex. Today is 01/01/2021 then next day is 02/02/2021.
8. Auto copy sheet with rename by previous estimate number continuation at same time update the target cell "J6".
9. Auto clear contents in customer details, estimate fields, old purchase fields while create copy sheet.
10. Auto update sales report and customer details one by one after estimate creation.
11. Please make button click for above all formats and copy sheet.
12. I want all format button click in each and every sheet.
13. I want auto print setup page for print estimate.
I want the all above requirements for "Full Automated Estimate" creation. My humble request to help with VBA function.
I have attached here my requirement file for kind reference.
Lot of thanks and regards.
Attachments
Last edited: