Attached is a very generic version of a current project. Initially, the first five cells of each row in the UserCost Table in the Costs Worksheet were supplied by another method within the VBA program. However, with the need to have the two Tables synced, I manually inserted the appropriate formulas that would allow for the first five cells of the UserCost Table to be synced with the Log Table in the LogFile Worksheet.
Where the difficulty arises is writing the VBA code so that when a new row is inserted, those same formulas can be written into each cell. I was able to do this in the frmUnits Code, but it's not translating over.
The code is in Sheet3 ("LogFile") and starts "With Sheet4". Those lines of code in question are commented out, as errors kept arising. Would anyone know how to write this type of code?