I made a table next to a table of employees.
This table has formulas that I would like to preserve (auto-populate) if someone inserts a row.
But if I try to insert a row across sheet, it is grayed out.
My users do not know excel so trying to tell them to do two different "Insert Into Table" is not going to work.
Anyway around this or is a macro the only way?
thanks
Pete
This table has formulas that I would like to preserve (auto-populate) if someone inserts a row.
But if I try to insert a row across sheet, it is grayed out.
My users do not know excel so trying to tell them to do two different "Insert Into Table" is not going to work.
Anyway around this or is a macro the only way?
thanks
Pete