Substract cells using vba

[cambi]

Hi Guys,

Im trying to substract from a cell using a togglebutton
the idea is that when I press the "Record Daily Production" I can substract the kgs produced on the "T" column to the kgs ordered in "R" column
the same with cases from column "U" to the cases from column "S"
I have around 1000 rows so it takes forever checking all rows.

Thank you in advance

 

[rlv01]

the idea is that when I press the "Record Daily Production" I can substract the kgs produced on the "T" column to the kgs ordered in "R" column

Your screen shot indicates it is not a 1 to 1 relationship for kgs ordered vs. kgs produced so what is your intent for deciding which Col R value and which Col T value to use in the subtraction operation for your 1000 rows of data?

 

[cambi]

Your screen shot indicates it is not a 1 to 1 relationship for kgs ordered vs. kgs produced so what is your intent for deciding which Col R value and which Col T value to use in the subtraction operation for your 1000 rows of data?

Hi rlv01

im using VBA to add kg orders into row R and row T is pulling information from a report using "SumIF" formula,

I want the command button to to substract the kgs produced in column T to the amount that I have in column R and keep the result in column R,

basically is it possible that when i click the command button "Record Daily Production" that the KG remainings from the equation to be 1000kg (1500kg - 500kg=1000kg)
but for all rows with data on them rather than just that row.

I dont know if that makes more sense,
Thank you in advance

 

[rlv01]

I dont know if that makes more sense,

Not really. You did not answer my question about how you intend to handle the one-to-many relationship

You would probably be better off posting some sample data along with what results you are expecting and where you are expecting them to go. If your 1000 rows of data contains more than one value for 'kg ordered' or spans more than one day, your sample data should as well. Also, if you post data as a screen shot as you did above, most people will move on to someone else's problem since life is too short to manually re-type it in order to experiment. Better you should use the free XL2BB tool (link below) to post your data in a way that makes it accessible to others.

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com