Manual file handling could be a reason behind your enterprise burning off money along with your staff members losing interest in their responsibilities. The simplest way to boost all business processes and enhance your stats is to deal with everything with cutting-edge software like DocHub. Handle all your documents and Save Customer Complaint Form in Excel in a matter of seconds and save more time for pertinent duties.
With DocHub, you have unrestricted use of your documents and Templates available to you at any moment. Discover all functions right now with the free DocHub account.
hello in this presentation i want to show you how to create a professional customer complaints record to keep the evidence up to date i will use an star.xlsb file in order to allow running macros and also to keep the file dimension as small possible when its filled with thousands of records per year there are two sheets first with records and second one with suppliers name and info about them you can see the evidence of complaints for each supplier also in a chart in order to have same format for all cell containing date i will use same data validation for all of them from data tab select data validation as you can see and fill according to presentation then copy this cell and paste it to all others next i will show the formulas working with date month formula will return only this value from reference cell next formula will obtain the quarter from previous cell to add q before quarter number i change the cell format as shown this formula will calculate the number of days between cel