Heres the basics of what i have to do: I have an excel document in which i need

Question

Heres the basics of what i have to do:

I have an excel document in which i need to add a macros button done in Visual Basic. The functions are as follows;

1) From input values, take the sum of a range of cells. Example: Stage On: 100; Stage Wanted: 200; add sum from stage 100 through 200. Cell location for stage on A:101, value wanted for Stage On: B:101. So i want to take the sum of the vaule for stage on which are found in the B cells 1 greater than current stage.

2) divide answer of sum of stage values by third input value.

3) subtract total found in step 2 by difference between stage on and stage wanted and print answer in designated field

Thank you for all help. big points for this one.

Heres the basics of what i have to do: I have an excel document in which i need to add a macros button done in Visual Basic. The functions are as follows; From input values, take the sum of a range of cells. Example: Stage On: 100; Stage Wanted: 200; add sum from stage 100 through 200. Cell location for stage on A:101, value wanted for Stage On: B:101. So i want to take the sum of the vaule for stage on which are found in the B cells 1 greater than current stage. divide answer of sum of stage values by third input value. subtract total found in step 2 by difference between stage on and stage wanted and print answer in designated field

Explanation / Answer

hey..can u mail the excel sheet so that i'd try ?

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---