I have columns that have formulas which are not part of the userform. When I add a new record only the fields from the user form are added to the new row. However, I have columns with formulas that need to be copied down once a new record is added.
Currently the columns that need to be copied down are col O and then T thru AB. However, I would like any new added information that is not part of the form to be added automatically.
In the attached file I highlighted in yellow what column rows need to be added each time a new record is added. In this attachment there are no formulas but in the original these columns are formulated.