Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

What you describe is not possible using cell formula. A cell formula can only change the value in the cell that contains that formula.

It might be possible to write a user defined function that would change some other cell value but this is not recommended and could possibly cause LibreOffice to crash.

The best method to achieve what you describe would be to create a macro that would execute from a button located on your data entry sheet, which would find the location of A3 in your stock sheet and add the value from A5 to the balance.

Demo example in attached Untitled 35.ods