Forum Discussion
Thibault1305
Nov 13, 2021Copper Contributor
Adding rows to a table without previous values getting updated.
I have an example where I want a table to be made with values from certain cells on the same worksheet. These cells providing the input for the table change. So when extending the table the value is ...
Subodh_Tiwari_sktneer
Nov 13, 2021Silver Contributor
You will need VBA to achieve that. Would you please share the layout of the Sheet? i.e. a sample excel file, not an image?
Thibault1305
Nov 13, 2021Copper Contributor
Yes I have uploaded the file, I've used fictional numbers. The thing that I want is in the 'Net Worth' sheet, when adding a line in the table the values get extracted from the small table on the right where the saldi are. And the older values not being updated. Thanks