I have created a timesheet that employees select the task they worked on for a given week and add the hours they worked against this task. There are a number of formulas that are associated to each entry field - for example, the hours worked are added to an overall sheet tracking total employee hours worked on a given task within a given project.

What I'd like to do, is for a new line to appear only an item is selected from the drop down, which would save me from having 10 empty lines where employees would select a task from the dropdown each time. Importantly, I'd like the new line that appears to keep the relevant formulas from the line above if possible.

Is this possible?