Forum Discussion
Adding rows to a table without previous values getting updated.
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?
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
- No, not yet.
1. That is indeed the purpose, the values will be updated automatically when adding transactions to sheet 1 and refreshing stock data.
2. It is not exactly each time the input changes that I would want a new row to the table, but more when I choose to add a row (for example when I've updated the date on sheet 1) and I decide all changes have been made.