How to auto calculate value based on different sheets

Good day, I am very new to advanced excel and this is my first post and I hope I can get the answer soon. Thank you in advance.

I have two sheets in one excel 2007 file:

sheet1: used to calculate interim result based on a cell say D1 and the result shows in D2

sheet2: has a column E that will feed the value to sheet1's D1

I need the excel to calculate the final result for all the datafeed in column E, sheet2, and shows result in column F, sheet2

Is this possible?

Thank you very much.

Thanks for the remind, here is the excel file, Mgt is sheet 1 and ROI is sheet 2.
Sheet Mgt: D11 is calculated based on D6 (off course many other fields in the sheet)
D6 will be feeded from sheet ROI H3
ROI I3 is copied from Mgt D11

For each cell in H column in ROI, I need the cell in I column be calculated automatically.

I hope this is clear but I would explain more if there is a need.

Thank you very much.

Thank you very much for your quick solution, I guess you are very close to it now, can you make the change directly on the file and post it back here? I think I input a fix reference in Mgt!D6 and you referenced in your formula a sheet that doesn't exist.

Thank you.

Or are you using the Mgt sheet at all?

All I need is to calculate mortgage monthly payment automatically based on the loan for data feeded in sheet ROI, I am not sure if you have better solution that do not need the sheet Mgt but any better solution is surely welcome

Originally Posted by FDibbins

there is no mgt sheet, the file you uploaded has 2 worksheets - ARMcalculator and ROI

I used the formula from ARMcalculator D11, and adjusted it so that you can use it in ROI I3 down

OK, maybe I changed it after I uploaded.

Anyway, thank you very much for your kind help, I really appreciate it.

it resolved my main issue, the other question remains:

Another question here:
ROI!G3 = K3*D3

If I drag it for the whole column of G3, I got G4 = K4*G4 but it works only if K4 exists

In my sheet, K4 was manually typed in because K3 = =CHOOSE(L9,0.35,0.5), L9 references to an option control on the top of the sheet: 35% or 50%

If I copy down K3 to K4, it gets =CHOOSE(L10,0.35,0.5) but L10 doesn't exist

Can you tell me how to fix this problem?

Thanks.

You can see there is an option control on first row of sheet ROI, L9 is in light color and links to the option control. if you select 50%, L9's value will change from 1 to 2

I hope this clarifies.

Thank you again for your kind help.

I figured it out now: the answer is very simple, I only need to make changes like A1 to $A$1 then A1 won't be auto changed.