Ask Your Question
0

libraCalc Formula help plzzz

asked 2015-03-25 12:25:26 +0200

toxicgoat gravatar image

i have a drop down list in column A3 with a few items . i wanna enter a value in column a5 and then on a different sheet i would like the value i added to be added to the correct item that was selected in the drop down list . So i select bananas from list. i then enter a value in a5 and it must then update a stock sheet i have created .. Any ideas on how to do this .?

edit retag flag offensive close merge delete

Comments

Do you mean simple =$Sheet1.$A$5 ?

JohnSUN gravatar imageJohnSUN ( 2015-03-25 12:40:35 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2016-10-23 18:54:57 +0200

adam1969in gravatar image

If you have the dropdown items in Column A of Sheet2, then add this formula in Column B of Sheet2.

=HLOOKUP(A1,Sheet1.A3:A5,3,0)

edit flag offensive delete link more
0

answered 2016-10-24 02:05:35 +0200

mark_t gravatar image

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-03-25 12:25:26 +0200

Seen: 60 times

Last updated: Oct 24 '16