Forum Discussion
Want to keep same number (payrate) in a column that is hidden when inserting a row.
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.
It works for me - I tested it.
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
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