How to: Macro to divide/multiply and show results

Hello.

I know this one is an easy macro but im still a rookie and can't make it yet

As you can see there are 2 buttons,
what i want is to click "Cartons" so the macro will divide pcs/carton by Stock and display the result in the row: Stock
The other button is the "Pieces" which i want to make to multiply pcs/carton with Stock and display in the row: Stock

I would be really glad to have some help with this, fighting with excel for a long time now

excelreqhelp.jpg

Try this...

Hi.

abduljaleel.mca

Yes something like this but instead of displaying the result in a 3. column it should replace the numbers in the "Stock" column, and it should apply to all the rows in the xls.
also i figured out another problem.

there are 60pieces on stock this is the default value. if you click pieces again it multiplies it and the number is not accurate anymore.
It should be like: 60 by default, and when clicking pieces. and 10 when i click carton because 60:6

it looks even more complicated than i thought


Xlbiznes i would use a formula, im not sure that i can attach formulas to a click of a button. is that possible?

So let me sum just to make it clear

The cell in pieces should be 60. this is the stock in pieces, when i click the button: "Pieces" at this point it should not change because it would give a wrong stock.
When i click the "Carton" button it should replace 60 with 6 because: 60:6, when i click pieces after this it should replace 6 with 60.

Looks pretty hard for me, anyone can solve this please?

anyone?

yes it is very clever, my only problem is that i cannot add another column because the "Stock" column should show the pcs or cartons regarding what i choose, but the Stock cells are already a formula summerizing the incoming and outgoing goods.
So it would be ideal for me to change the Stock column for a push of a button to represent Carton or Pieces.

I really appretiate your help, it brings me closer to the solution but im still not there

So i guess it is impossible to make something like this in Excel.

still hunting for a solution.