[For Loop] Apply Exchange Rate Calculation to Cells

[nsturk725]

Hello,

I need help writing some VBA code. I think this will be a very simple For-Loop, but I am not sure how to structure the code.

Here is what I want to do.

CONCEPT = Take the fixed exchange rate value and multiply it against the dollar amount.

DETAILS:

Exchange Rate = value of cell "D3" (lets say the rate is 105)

Dollar Amount = value of cell "C6" (there will be over 1000 cells to loop through)

Exchange rate impact = calculated value input into cell "D6" (D3 * C6 = D6 cell value)


As long as there is data in column C (starting at cell C6), I would like to multiply the respective C-Cell value by the fixed value of cell "D3" and input that calculation output into the respective "D" column cell.


Please see the attached example.

I would appreciate any assistance you guys could provide.

Thank You Very Much.

[nsturk725]

I was able to figure it out.