I want to keep same number (payrate) in a column that is hidden when inserting a row. I already have a table applied. The formula is automatically in the new row but when I enter data for the formula to calculate it does not compute because the payrate did not drag down.
Column D, G, and J are hidden and thats where I need the same number (payrate) to automatically fill as I insert new row for the fomula.
Column D, G, and J are hidden and thats where I need the same number (payrate) to automatically fill as I insert new row for the fomula.