Hi, what I basically want to achieve is the following scenario:
When I insert new values into a table, the new row is created. I would like Excel to automatically duplicate also the other columns (not only those from the table),
like O2 and O3, so that I do not have to always press CTRL and copy them down all the time when I create a new record in the table.
Any ideas?
Thank you for your help in advance.
Code:
[B]A1 - TABLE HEADING [/B]O1
A2 - 1 2 3 ="A2"
A3 - 4 5 6 ="A3"
When I insert new values into a table, the new row is created. I would like Excel to automatically duplicate also the other columns (not only those from the table),
like O2 and O3, so that I do not have to always press CTRL and copy them down all the time when I create a new record in the table.
Any ideas?
Thank you for your help in advance.
Last edited: