Excel function loop between two sheets

  • Thread starter Gabor Kopjan-kiss
  • Start date
G

Gabor Kopjan-kiss

I have to make a torque calculation of a rotating part to the rotation point.
And i want to make it upgradeable, when new loads are apllied i want to
easily insert them. So i started the whola calculation with two sheets. The
first contains the parameters of the loadcase: point, coordinates, force
directions moment values and the place vector parameteres: radius and angle
from vertical direction. On the second sheet i have different position angles
in which positions i have to calculate the torque. The angles are in a
column, and in the second one shall be torques. So in the functions i use on
the first sheet i use the position angle as a paramterer which is constant
for just one calculation, but then it have to change. i have the formula
which i want to copy into five lines, with the same position angle, then sum
them. But after this step i want to copy the sum cells value to the second
sheet and there copy from one row to another with the automatic change of the
angle value, and an automatic recalculation.

Is there any way to do this, os i have to calculate it in all the angle
positions in different sheets? The number of positions and the steps are
changeable, also the limits.

Thank you very much
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top