Forum Discussion
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 ...
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?
- I uploaded it to the original post.
Let me know if I understood this correctly.
1. The Input Table (Table6) will have only three rows which you can update by inputting new values in Saldi Column in the range N3:N5.
2. Each time you update the Input Table, you want a new row to be added in Table5 updating the columns C, D and E where N3 value will go in column D, N4 value will go in column C and N5 value will go in column E.
Is that correct?
Have you found a solution? Subodh_Tiwari_sktneer
- 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
