Forum Discussion
Solved
Want to keep same number (payrate) in a column that is hidden when inserting a row.
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...
tommy1292 The cause of your problem is the inconsistent table setup: you used the first data row as header row. That prevents formulas from being copied automatically.
I moved the headers to the header row, and redid all the formulas. It now works correctly for me.
See the attached version.
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.
tommy1292 The cause of your problem is the inconsistent table setup: you used the first data row as header row. That prevents formulas from being copied automatically.
I moved the headers to the header row, and redid all the formulas. It now works correctly for me.
See the attached version.
- Ah!! Thank you so much!! Life saver