Hi I am doing calculations of number of reducers i.e 10. However evertime I do calc for the next reducer, I will have to copy and paste to the table with reducer number (see attached workbook). Recently I had to work with about 80 reducers and this is some what cumbersome.
All want to know is there a way I can input data on the green shaded areas and change it as per reducer size and excel will copy the required data to corresponding reducer number automatically.
Reducer 1, D= 1500mm, d1=1200mm and calculated x=1050mm
Reducer 2, D= 1000mm, d1=900mm and calculated x=350mm
Reducer 3, D= 1000mm, d1=800mm and calculated x=700mm
Your help will be appreciated
All want to know is there a way I can input data on the green shaded areas and change it as per reducer size and excel will copy the required data to corresponding reducer number automatically.
Reducer 1, D= 1500mm, d1=1200mm and calculated x=1050mm
Reducer 2, D= 1000mm, d1=900mm and calculated x=350mm
Reducer 3, D= 1000mm, d1=800mm and calculated x=700mm
Your help will be appreciated