We are currently using this form for rating training.
We are adding a conditional formatting to Cells K35:N39 to change it yellow based on variables.
But we would like to see if we can change the worksheet so we do not have to have 40+ groups of rows in the spread sheet and auto create the group such as A32 through N41 as needed.
See sheet WOULD LIKE TO CHANGE TO for problem and details.
I would like to be able to add a set of rows to be filled in by the user while keeping the same formatting and averaging.
So once cells A32:N41 is complete I would like to have it create a new group of cells bellow it.
The kicker is cells E33:E39 and Cells J33:J39 are averaged in their respective cells in rows 12-18.
Also the check box in cell N34 is adds 1 to Cell I9 and is summed up by each subsequent Check box in subsequent cells created
I know how to create one row automatically with the same formatting.
I just can’t figure out how to create multiple rows with the calculations in cells F12:F18 and M12:M18 intact.
Also I cannot get the check boxes to come across.
The only Check box with a formula attached is in N34 the rest only indicate a category.
Is this possible?
Bookmarks