Our Excel VBA consultant created a daily form on Excel for a construction company to record daily tasks. On the form, the construction company enters daily tasks, hours, rate and material cost. Using formulas, values such as cost plus and total will be calculated. They can create a new form for a specific day just by clicking a button.
With a click of a button, the summary of all these daily tasks will be exported to a master monthly sheet. They also could convert individual or entire sheets to PDF.